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

System Stored Prodecures Expand / Collapse
Author
Message
Posted Tuesday, September 29, 2009 9:43 AM


Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, September 24, 2014 4:13 PM
Points: 11, Visits: 579
Hello,
We're using SQL Server 2005 SP2.

Recently, any new procs that we've created under Master, are visible only under the System Stored Procedures folder.
With 2000, we could use EXEC master.dbo.sp_MS_upd_sysobj_category 2 to disable this function.
How can do the same for 2005?

Thank you,
JG




Thank You,
JFG
Post #795248
Posted Friday, October 2, 2009 3:04 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, March 19, 2014 9:54 AM
Points: 241, Visits: 442
I have a sql 2005 sp2 box right here, I created a sproc and it appeared under programability/stored procedures.. not under system stored procedures..

can you give me an example of your create script and tell me how you're running it?


--------------------------

I long for a job where my databases dont have any pesky users accessing them :)
Post #797247
Posted Friday, October 2, 2009 3:27 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 7:17 PM
Points: 5,332, Visits: 25,261
Looking at that procedure in 2000 there is the following:
-- NOTE: THE IMPLEMENTATION (ie. using trace bit 1717) IS *VERY* LIKELY TO CHANGE,
-- SO DONT EVEN *THINK* ABOUT USING THIS TRACE BIT DIRECTLY!!!
if @pSeqMode = 1
--- Undocu trace 1717. Now MSShipped bit will be set auto at Create time.


So I would be tempted to say when using SSMS make sure you select the correct database, that is the DB you want to create the SP within My guess would be that setting this trace bit also effects other system internals and would be something you would not want to alter.


If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Post #797264
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse