The code highlighted in red is trying to put round, square, triangle, and oval pegs into a square hole. My advice is to scrap this section of code, and handle...

You can either:

A. make the user the actual database owner using sp_changedbowner. However, a database can have only one actual owner.

B. alias the user to dbo using sp_addalias. Any number...

If your rowcounts are high for either the msdb..restorefile or msdb..restorefilegroup tables, try creating indexes on restore_history_id (they have no indexes as shipped). An index on msdb..backupset.media_set_id might also help.

Any...

This IS a great site. Your post struck me in particular, both because of your experiences with managers and coworkers, and because you admitted to heavy drinking. I, too, am...

All the "bcp tablename in" portions can be replaced by using the bulk insert SQL statement.

For the others, either a rewrite as a client program, in a language that has...

I would prefer either clustering or a standby server over replication. Although many shops use replication, I suspect many of them do so because management read about it somewhere and...

If this post appears, then your suggestion worked! Thanks.

Good points about auditing. However, login proliferation was considered by the customers to be worse. Logins with permissions in more than one database (likely a competitor's) were forbidden, with the...

I think "It depends" is a good answer. When I suggested using an SQL login like [database_name]_dbo, I failed to make clear the nature of our environment. We were an...

IMHO, [the guy who makes database design decisions] has a good idea. Shops I have worked in have found this sort of information very useful in tracking down problems, be...

Re: One, with a login per database (as the owner) there is an extra account per database. Since that account is owner of the database, yeah, you guessed it. Bad....

The convention at my previous shop was to create a SQL login with the same name as the database, but with _dbo appended, and sp_changedbowner to that login. Another SQL...

Brian's recommendation is safer and more informative. I sometimes have a one-track mind, and get carried away...

Well, my idea didn't work, but a close relative will:

sp_configure 'allow_updates', 1

reconfigure with override

begin transaction

update sysobjects set xtype = 'TR' where xtype = 'TR'

This WILL block any attempts to disable...

You may be able to execute a procedure at startup to do what you want. From Books Online (CREATE PROCEDURE):

Automatically Executing Stored Procedures

One or more stored procedures can execute automatically...