Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Currently in Delaware, US.
    Posts
    5

    Red face Unanswered: Execute Stored Procedure menu not appearing

    Hi,

    I have created an SQL Server instance in SQL Server Management Studio. I have a few databases, and stored procedures in them. When I right click on the stored procedure, I have the menu for "New Stored Procedure, Modify, Script Procedure as, and so on". But, I could not see the "Execute Stored Procedure" item.

    Could any one help to find out what could be the problem and solve it?

    Thanks,
    Luke.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Stored procedures in 2000 must be executed from a utility such as Query Analyzer.
    I think the 2005 management interface allows you to execute them directly and submit parameters, but I'd have to check to be sure.
    Regardless, it is not good to be doing these types of activities in the GUI. Use QA instead.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •