Don't!

DTS is outta here with the release of SQL Server 2005 - study SQL Server Integration Services instead.

DROP DATABASE removes the database from SL Server and deletes the files from the disk.

Aah, not if I understand you correctly.

SQL Server on a SAN, yes, database mirroring on these servers, yes, 'point to the same databases', no.

Some people use SANs to solve the...

--Try:

sp_addrolemember 'db_backupoperators', 'youruserhere'

What kind of backups and what frequency is Veritas performing?

Simply having it installed isn't enough.

"If the database recovery model is set to either bulk-logged or simple, some INDEX DDL operations are minimally logged whether the operation is executed offline or online. The minimally logged...

Yes, database mirroring is not a reporting feature - it is database snapshots, and they are enterprise level.

Err, I assume you mean changing mode to simple.

Log shipping can be performed under full or bulk-logged.

I was refering specifically to the rebuilding of indexes which is expedited through the use of BULK-LOGGED.

Yes, ALTER is new to 2005 - everything is done through CREATE, ALTER, DROP...

My response is for SQL 2005.

"...which includes re-indexing and other such intensive activities, can fill up a transaction log in a hurry, **even with the BULK-LOGGED recovery option.**"

That's not true.

I'd suggest implementing database mirroring instead...

That's server level auditing, not a trigger:

Go to the properties of the SQL Server, go to Auditing and select sucessful, faulre, all or none.

I'm at a loss to explain why no-one suggested you use the copy database wizard. It'll migrate the users as well.

From the original post it apeears that the users create and execute the procedures.

If you set a default schema for the users, then the sps will also belong to that...

The cpomlicated bit is installing the cluster service and creating the virtual servers.

In 2000:

http://www.microsoft.com/windows2000/techinfo/planning/server/clustersteps.asp

After that you just run the SQL Server setup, it detects the cluster, you pick...