Sql Server Enterprise manager and stored procedures

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Mythilid
    New Member
    • Feb 2007
    • 1

    Sql Server Enterprise manager and stored procedures

    I' m new to sql server enterprise manager,I want to know how do you start a new stord procedure for a database.When I try it by right clicking on the database and new stored procedure button is disabled. should I change any setting, Please help.
    Thanks in advance
  • iburyak
    Recognized Expert Top Contributor
    • Nov 2006
    • 1016

    #2
    Example

    [PHP]
    Create storedproc Procedure_Name
    AS
    BEGIN
    Your code here.
    END[/PHP]

    Comment

    • iburyak
      Recognized Expert Top Contributor
      • Nov 2006
      • 1016

      #3
      Correction:

      [PHP]Create proc Procedure_Name
      AS
      BEGIN
      Your code here.
      END [/PHP]

      Comment

      Working...