System Stored Prodecures

  • 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

  • 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 🙂

  • 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[/url]
    Before posting a performance problem please read[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply