I am a bit confused here

4. Under "EM >Security >Logins" I create the NT login "<SQLServerName>\SQLUsers" and grant that group "sa" equivalence.

Are you saying you created a Group in SQL...

I think your ISP will not guarantee the replication. Personally the more control you have the better as they will generally guarantee uptime and backups, no more.

Trigger are simple and...

ALso, are you seperating tables into individual filegroups or is it one table spanning multiple filegroups. If the later you just have to run DBCC SHRINKFILE with the EMPTYFILE option...

One option you have as long as you are sure the encrypted items do not use the 3 or 4 part name to reference objects (server.db.owner.object or db.owner.object) is this....

You are limited in some of the things you can do with a table variable where a temp table is not as limited. My opinion is use Table variables on...

Just build the entire string including the declares within the Dynamic SQL string. It will build them in the same scope then.

Ex.

Won't work

DECLARE @int int

SET @int = 5

EXEC('SELECT @int')

Will work

EXEC('DECLARE...

Unfortunately as I remember you cannot shirnk the data. However restores on SQL 6.5 are such a pain I suggest bringing up a new server for SQL 7 and use...

Review the process that are specifically causing the blocking. You have to determine what needs to be fixed. Could be adding indexes, rewriting queries, or maintainence on a db. But...

Yes all changes to master are considered critical and you cannot leave the DB offline to recover additional backups to master so Full Backup is all that is supported with...

Also try these 2 (sorry I rolled into one but gives 2 output)

First output column is houtrs expressed as total hours and hundredths of an hour and will span days....

You also have the option of using CDOs AND CDONTs to send via SMTP. Or better to cut down on contention and other issues write message to a table and...

Both are about the same. Except two can run a suboptimal plan many times in a Stored Procedure and the first can result in locking issues with the source table....

Steve specifically why would you not use the 127.0.0.1 or localhost as you are talking most likely having the connection string in a session or app variable (I prefer app...

Sounds right, if you get a lot of feed on the command prompt window and the cursor does not return. However, use QA to attach. EM I do believe does...

Try using DBCC INDEXDEFRAG, I believe that is not logged where DBREINDEX is.