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 |
|
rushdib
Yak Posting Veteran
93 Posts |
 Posted - 2003-12-02 : 09:58:17
|
| Hi,I scanned one of our servers using the Best Practice Analyzer and it found some user objects in master database. There are some user objects which does nto follow our naming conventions. I am reluctant to delete those objects. Does the master db can contain only system objects?Thanks,Rushdi |
|
|
VyasKN
SQL Server MVP & SQLTeam MVY
313 Posts |
Posted - 2003-12-02 : 10:45:56
|
| There is nothing stopping you from storing your own objects in master database, but it is not considered a good practice. You may even lose your objects from master database, when you do an upgrade to a next version.I create my own utilities database, and store my general purpose stored procedures in that database. But sure, there are some cases, when you want your stored procedure to behave like a system stored procedure, and that's when I create a procedure in master database.--HTH,Vyashttp://vyaskn.tripod.com |
 |
|
|
|
|
|
user objects in master database