System Stored Prodecures

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » System Stored Prodecures

System Stored Prodecures

Rate Topic

Display Mode

Topic Options

Author

Message

John Garcia

Posted Tuesday, September 29, 2009 9:43 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 10:02 AM
Points: 11, Visits: 441

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

torpkev

Posted Friday, October 02, 2009 3:04 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, August 26, 2011 7:59 AM
Points: 238, Visits: 432

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

bitbucket-25253

Posted Friday, October 02, 2009 3:27 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 5:36 AM
Points: 5,101, Visits: 20,202

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 »

Permissions