Posted by Crazy Cat on 12/22/05 00:20

Responding to my own post - I created a store procedure and deleted it
then couldn't locate it. I guess if you don't specify the database and
owner, by default the stored procedure is copied into the Master
database under system stored procedures (!), so if you can't find your
stored procedure, this is probably a good place to look.

Still perplexed about why users are allowed to store stuff in the
System Procedure folder and why this is where procedures with
unqualified names are stored by default.

[Back to original message]