SQLServerCentral.com / SQL Server 2005 / T-SQL (SS2K5) / SQL 2005 SP in Master DB With Category 2 / Latest PostsInstantForum.NET v2.9.0SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 03 Mar 2015 13:59:12 GMT20RE: SQL 2005 SP in Master DB With Category 2http://www.sqlservercentral.com/Forums/Topic519899-338-1.aspxIn that case, I'd let Microsoft know that it might be a bug in Mangement Studio. Sounds like it to me, anyway.Fri, 20 Jun 2008 12:04:04 GMTGSquaredRE: SQL 2005 SP in Master DB With Category 2http://www.sqlservercentral.com/Forums/Topic519899-338-1.aspxNo, 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.Thu, 19 Jun 2008 12:07:41 GMTpnewhartRE: SQL 2005 SP in Master DB With Category 2http://www.sqlservercentral.com/Forums/Topic519899-338-1.aspxDid you name them "sp_"+something?Thu, 19 Jun 2008 10:52:53 GMTGSquaredSQL 2005 SP in Master DB With Category 2http://www.sqlservercentral.com/Forums/Topic519899-338-1.aspxI'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.Thu, 19 Jun 2008 08:20:53 GMTpnewhart