CANNOT FIND STORED PRECEDURES!!!!

hello all,

i'm learing how use stored procedures... know how create them "create procedure..." syntax....  run query , creates successfully.  can run them "exec sp_name" , run find.... when cannot find them anywhere in object explorer.  raise question because delete , modify some. 

i'm using sql server management studio express 2005

much appreciated!!! 

thanks in advance,

corey

---

relax.....i'm new @ this.

hello,

you have created stored procedure database mydatabase, in query window have typed definition
of stored procedure, have forgotten begin by
use mydatabase
go

if case, find stored procedure among stored procedures of default database of user using connect sql server instance ( if have not defined default database, master database default database : right-click on master ==> stored procedures , should find stored procedure in "user" not system stored procedures of master database )

i have done error several times , each time had delete here newly creatly stored procedure.
you can check easily
try recreate stored procedure without forgetting use followed name of database.
you error saying stored procedure created.
you cannot create stored procedure database same name of stored procedure existing in master

we waiting feedback try more efficiently

have nice day

---

please remember click 'mark answer' on post helped you. unmark if provides no help

SQL Server  >  SQL Server Express