Can't right click on a stored proc and Execute with sql express?

  • I've gotten very used to opening mgmt studio, connecting to my full sql install, right clicking on a stored procedure, choosing Execute and having that nifty dialog box with all the parameters popup for me. Recently I've been doing work in some other people's local instance of SQL Express and this doesn't seem to be an option....is there something I'm missing?

  • Well I am looking at the Execute Procedure dialog right now in 2005 MS Express.

    Actually it is better than the old Query Analyzer version (wow! remember that?) in that it allows a view of every parameters' attributes all at once (you don't have to click each entry).

    The other difference that I can see is when right clicking a Proc. you select Execute Procedure rather than Open.

    HTH

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply