I am a proponent of the manual scripts method (with some automation ).

Most of the drawbacks listed by the author can be summarised as...

Im not clear what you want to do but have you looked at triggers?

By placing triggers on a table you can intercept a command and get the system to behave...

I have had this message a couple of times since applying SP3 to SQL2K.

We have massive free disk space (40GB+) and only a small logfile on tempdb (200Mb).

I have...

I have found that getting programmers to work with SQL sproc scripts on disk gives a very high level of control. This means you can use a script to extract...

Temp tables (those whose names start with a #) are session aware and are created in tempdb. In an environment with a lot of concurrency there can be locking issues with...

We had similar problems on a number of SQL Servers after upgrading from Exchange 2000 to Exchange 2003.

I found that the problem self-corrected after restarting Sql Server.

A restart of the...

I have had this message a couple of times since applying SP3 to SQL2K.

We have massive free disk space (40GB+) and only a small logfile on tempdb (200Mb).

I have seen...