Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2005 SP in Master DB With Category 2 Expand / Collapse
Author
Message
Posted Thursday, June 19, 2008 8:20 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 18, 2014 8:00 AM
Points: 268, Visits: 279
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.



Post #519899
Posted Thursday, June 19, 2008 10:52 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #520027
Posted Thursday, June 19, 2008 12:07 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, July 18, 2014 8:00 AM
Points: 268, Visits: 279
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.


Post #520098
Posted Friday, June 20, 2008 12:04 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 15,444, Visits: 9,596
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
Post #520947
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse