"sharman" <shar***@discussions.microsoft.com> wrote in message
news:1AE77056-D6A4-42F1-B040-EBE5253C928F@microsoft.com...
> Hi,
>
> I am having a peculiar problem. I have a SQL Server 2000 with 8 databases
> running on it. If I try to create a Stored Procedure on any of the
> databases
> except master I am able to create it without any problem. However, if I
> try
> to create it on master I get an error message that the object already
> exists.
> I have tried giving it different names like XYZ or ABC and still I get the
> same message. I try to query sysobjects table for that name and I don't
> get
> any results. Am I doing something incorrectly? Is there any dbcc otion
> that
> is preventing this? I am using the sa login. Thanks in advance.

"Greg D. Moore (Strider)" wrote:

> "sharman" <shar***@discussions.microsoft.com> wrote in message
> news:1AE77056-D6A4-42F1-B040-EBE5253C928F@microsoft.com...
> > Hi,
> >
> > I am having a peculiar problem. I have a SQL Server 2000 with 8 databases
> > running on it. If I try to create a Stored Procedure on any of the
> > databases
> > except master I am able to create it without any problem. However, if I
> > try
> > to create it on master I get an error message that the object already
> > exists.
> > I have tried giving it different names like XYZ or ABC and still I get the
> > same message. I try to query sysobjects table for that name and I don't
> > get
> > any results. Am I doing something incorrectly? Is there any dbcc otion
> > that
> > is preventing this? I am using the sa login. Thanks in advance.
>
>
> My guess is you're not running as a SA account and have no rights to the
> master DB.
>
>
>
> --
> Greg Moore
> SQL Server DBA Consulting           Remote and Onsite available!
> Email: sql  (at)  greenms.com          http://www.greenms.com/sqlserver.html
>
>
>