June 19, 2008 at 8:20 am
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.
June 19, 2008 at 10:52 am
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
June 19, 2008 at 12:07 pm
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.
June 20, 2008 at 12:04 pm
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