Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

after making a non system stored procedure it appears in the system stored procedure folder Expand / Collapse
Author
Message
Posted Thursday, September 23, 2010 4:20 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:44 AM
Points: 87, Visits: 465
Hi,

i have this strange thing going on. when i create a procedure in the master database it appears in the system stored procedures folder. can anyone explain me how this comes. maybe something to do with the user mapping?? platform: sql server 2005 64-bits enterprise / os : windows 2003 64-bits enterprise

kind regards,

Bryan
Post #992396
Posted Friday, September 24, 2010 1:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, March 14, 2014 2:19 AM
Points: 2,820, Visits: 3,916
What is the name of that SP?

-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #992526
Posted Friday, September 24, 2010 1:36 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:44 AM
Points: 87, Visits: 465
the name is random. not a specific name op this SP. let's call it test.
Post #992529
Posted Sunday, October 10, 2010 2:25 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:30 PM
Points: 1,688, Visits: 8,759
Is your problem resolved?


MJ
Post #1001784
Posted Monday, October 11, 2010 1:25 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:44 AM
Points: 87, Visits: 465
My problem is not solved yet. i hope someone can help me on this one. maybe it's a user issue??
so normally when you create a stored procedure in the master database it will not end up in the system stored procedures folder, but in my case it is.

kind regards,

Bryan
Post #1001956
Posted Tuesday, October 12, 2010 3:37 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 6:05 AM
Points: 1,528, Visits: 5,172
You're not prefacing the name of your procedure with sp_, are you? That's reserved for system stored procedures.
Post #1002643
Posted Tuesday, October 12, 2010 4:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, April 14, 2014 6:44 AM
Points: 87, Visits: 465
No not using sp_.....
Post #1002659
Posted Tuesday, October 12, 2010 3:05 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 7:44 PM
Points: 446, Visits: 1,314
I've tested this on my SQL 2005 server and can't get it to save an object in System Stored procs.

Are you sure they are actually defined as system stored procs? In SQL 2005 the view is a bit misleading as there isn't a seperate User Stored Procs folder. All the user stored procs appear under "Stored Procedures", and there is a seperate "System Stored Procedures" folder on the same level, but it's at the top of the list, so it does look a bit like everythin is in that folder.

Cheers


Leo
Post #1003232
Posted Tuesday, October 12, 2010 5:03 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Thursday, March 27, 2014 6:04 PM
Points: 450, Visits: 991
what is the schema of your SP its not sys. right.

if you give the name with sys. spname it creates in system store proc.



--SQLFRNDZ
Post #1003290
Posted Tuesday, October 12, 2010 5:32 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, November 05, 2013 7:44 PM
Points: 446, Visits: 1,314
pavan_srirangam (10/12/2010)
what is the schema of your SP its not sys. right.

if you give the name with sys. spname it creates in system store proc.


I tested this and it wouldn't let me create a stored proc with the sys. prefix.
Also if you look in System Stored Procs you will see stored procs owned by dbo, so this isn't definitive.

I've looked in sys.sysobjects and can't see any way of identifying a stored proc as belonging to the system stored procs. I'm not sure how SQL determines this, does anyone else?

Leo
Post #1003297
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse