SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


System Stored Prodecures


System Stored Prodecures

Author
Message
John Garcia
John Garcia
Grasshopper
Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)Grasshopper (17 reputation)

Group: General Forum Members
Points: 17 Visits: 589
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
torpkev
torpkev
SSCommitted
SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1713 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 Smile
bitbucket-25253
bitbucket-25253
SSC-Insane
SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)SSC-Insane (24K reputation)

Group: General Forum Members
Points: 24009 Visits: 25280
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search