Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkk
Starting Member
4 Posts |
 Posted - 2006-09-12 : 04:55:42
|
| I'm running mssql 2005. And any stored procedure I create in the master database gets created as system procedures since recently. I have created procs in the master database as user procs previously. As sp_MS_upd_sysobj_category is not supported in mssql 2005, does anyone know why this is happening.. or how I can rectify it??Thanks... |
|
|
Pace
Constraint Violating Yak Guru
264 Posts |
Posted - 2006-09-12 : 05:11:03
|
[code]sp_MS_upd_sysobj_category @pSeqMode integer[/code]Enables/disables a special system mode wherein newly created objects are automatically system objects. Setting @pSeqMode to 1 enables this mode; setting it to 2 disables it. Among other things, sp_MS_upd_sysobj_category allows the creation of user-defined INFORMATION_SCHEMA views. sp_MS_upd_sysobj_category 1"Impossible is Nothing"  |
 |
|
|
kkk
Starting Member
4 Posts |
Posted - 2006-09-12 : 07:08:41
|
| that cannot be used in mssql 2005...My environment is a mssql 2005.. Any idea on what to do in a mssql 2005? And does anyone know what sets the master database to this behaviour??Thanks.. |
|
|
|
kkk
Starting Member
4 Posts |
Posted - 2006-09-12 : 07:21:24
|
| that cannot be used in mssql 2005...My environment is a mssql 2005.. Any idea on what to do in a mssql 2005? And does anyone know what sets the master database to this behaviour??Thanks.. |
|
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-09-12 : 10:28:52
|
| Why is this a problem? Why do you need to do this?CODO ERGO SUM |
|
|
|
kkk
Starting Member
4 Posts |
Posted - 2006-09-12 : 18:55:45
|
| Well I know that it's not good to have user procs in the master database.. but the fact is we do... I was able to create procs under stored procedures in the master database since recently.. But now if I create a proc in the master db, it goes under system stored proc. I'm not sure why this is happening now.. and how to rectify it.. |
|
|
|
anilkdanta
Starting Member
25 Posts |
Posted - 2006-09-20 : 08:28:13
|
| The reason may be any SP created in Master database must be a system stored procedure. Try Adding a new database ADMIN and create the SP here. |
|
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-09-20 : 11:20:08
|
| We're running 2005 and add procs to master that don't show up as system stored procs. Were you ever able to create non system procs in master? |
|
|
|
|
|
|
creating a user stored proc