Posted by Erland Sommarskog on 12/22/05 01:00

Crazy Cat (danbredy@hotmail.com) writes:
> 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.

First or all, there is no System Procedure folder, really. That is
just a visualization in Mgmt Studio.

Users are indeed permitted to create objects in the master database
if they have permissions. And, assuming that you have SQL Express on
your own machine, you presumably belong to BUILTIN\Administrators on
the box, and thus you have sysadmin when you log in with Windows
Authentication. And then you may indeed create procedures in the master
database.

Mgmt Studio has a dropdown which tells you the current database, and
this also displays on the tab, although it may be compressed. The Object
Explorer is not related to the query window.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]