SQL 2005 SP in Master DB With Category 2

  • I've got two stubborn SPROCs...both in the master DB. I've dropped and created them and also tried to alter them. They are not showing up in Management Studio as user procedures. They are showing up under system procedures. I cannot change the category bit for some reason...do I go ahead and update the sysobjects table directly?

    The stored procedures run just fine.

  • Did you name them "sp_"+something?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • No, they're all named UP_ I actually have a total of three. All start with the prefix UP_. One of the three gets categorized correctly. Basically, these are backup scripts, so I want them in Master. I read another article here that indicated I should name them with a sp_ prefix to allow them to be used in other DBs (as system stored procedures, but that's not the case). At first, I didn't see them under the system stored proc, but now I do.....it's more of a curiosity than a concern at this point.

  • In that case, I'd let Microsoft know that it might be a bug in Mangement Studio. Sounds like it to me, anyway.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

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

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