April 11, 2008 at 8:06 am
A group in our organization (DAG- Data Architecture Group) are pushing to add some tables and procs to the master database. The DBA's, including me, don't like the idea of non-system object in the master database. Does placing non-system object in the master database go against any best practices that you can think of? Any problems in upgrading? Is there supporting docuementation out there?
This group (DAG) have created these tables to monitor there own customized replication process as well as storing audit information about database changes. Both are home grown solution that I have my reseveration about.
April 11, 2008 at 8:20 am
Books online recommends not placing objects in Master. I'd recommend against it too.
Truth is, you can put objects there. You'll have to be much more careful about backups. You might expose security holes in your system, so be very restrictive in access to master. Always remember, if master goes away, so does the server.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply