Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  Missing 'Execute Stored Procedure..' in SMSS

Author  Topic  pw911 Starting Member 1 Post Posted - 2008-10-19 : 13:47:39 I recently replaced SMSS 2005 Express w/ SMSS 2005 Developer. When I connect to a remote Express server and right-click on stored procedures in Object Explorer, the options for 'Execute Stored Procedure...' and 'Properties' are missing! If I use a query window to EXEC a sp it works fine, so there is no permission issue etc.. When I browse my local (now Developer) server, the options DO exist. The options also exist when I browse a remote Enterprise server. What gives, and how to fix? I've seen no documentation on this as a known issue.