where is my stored procedure? (1 Viewer)

I've opened up SQL2005, under 'programmability' -> 'stored procedures' , I right click and select 'New Stored Procedure' , I create my procedure.

I close the window, it asks if i want to save, I say yes, give it a name, click save...

Now what? where is my SP?

ok, didn't realise I had to execute it to create it, i thought saving it would create it.

msdn.microsoft.com/en-us/library/ms345415.aspx

Click to expand...