CODEWITHSUNDEEP
sqlsql-server
FlyHeavies
FlyHeavies

Reputation: 29

New SQL Stored Procedure not showing in Object Explorer

I am using SQL Server 2005 on a client site. In the past I have created stored procedures in it with no problem. The last stored procedure I created does not show up in Object Explorer under "Stored Procedures". I tried saving it with and w/o dbo.

If I try to save another new stored procedure, the name of the one that is not displayed in Object Explorer appears as an option in the "Save File As" picklist.

Upvotes: 1

Views: 6755

Answers (1)

Kelewan
Kelewan

Reputation: 33

It will be added to the bottom of the tree when you execute/add the stored procedure. Refresh the Stored Procedure folder in the tree for it to sort it into alpha order.

Also ensure you are creating the Stored Procedure on the database by executing the code with Create Procedure before the procedure name. If you then need to edit the procedure simple modify (right click the procedure in the explorer tree) and change Create Procedure to Alter Procedure.

Upvotes: 2

Related Questions