September 29, 2009 at 9:43 am
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
October 2, 2009 at 3:04 pm
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 🙂
October 2, 2009 at 3:27 pm
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply