SQL 2005 SP in Master DB With Category 2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » SQL 2005 SP in Master DB With Category 2

SQL 2005 SP in Master DB With Category 2

Rate Topic

Display Mode

Topic Options

Author

Message

pnewhart

Posted Thursday, June 19, 2008 8:20 AM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:01 AM
Points: 267, Visits: 271

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

GSquared

Posted Thursday, June 19, 2008 10:52 AM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

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

pnewhart

Posted Thursday, June 19, 2008 12:07 PM

SSC Veteran

Group: General Forum Members
Last Login: Tuesday, April 30, 2013 7:01 AM
Points: 267, Visits: 271

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

GSquared

Posted Friday, June 20, 2008 12:04 PM

SSCoach

Group: General Forum Members
Last Login: Yesterday @ 1:55 PM
Points: 15,442, Visits: 9,571

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 »

Permissions