And be sure you know what columns are in the index before you drop it.

Read books online for the parameters for the create index command. You might want to note the fillfactor before you do this.

Good resume

Good backup

you only need one.

Get Log Rescue, I think it works on v7 as well. Read the logs. Then go get backups setup.

You don't need to use robocopy. Copy the files manually.

Are there people connected to the database?

If you want to move the files, detach the database, be sure you kill the users from it, and then attach it from the...

Pathing is based on the server, not the client. you might need to copy the file to the server.

The way you have this written it's not checking uniqueness, it's checking for an inquequality.

I think you want to check

if exists( select id from table where start= @start and...

If you ever have an issue from the warehouse, then you'll have to whack the snapshots and you'll lose them. While they're a nice way to get the snapshot, I'd...

You have written bad code in your scripts and are not properly checking for validation of parameters.

http://www.sqlservercentral.com/articles/Security/updatedsqlinjection/2065/

The SQL Server security service needs rights to start the service. Or a service. This isn't necessarily granted by default. You'd want to set an account for the SQL service...

Please don't post polls for questions. Use Add Topic.

This is covered in books online. For general questions, please do some research.

http://msdn.microsoft.com/en-us/library/ms175477.aspx

Please don't write in all caps.

The above solution is how I'd do it as well

I'm curious why you need to do this? If you remove Bob from SalesAdmin in AD, then he's gone from access to SQL? Or are you adding Bob to SQL...

Drop them and rebuild them on the primary filegroup. ALTER INDEX and CREATE INDEX have options for specifying the filegroup.

You can use Profiler, probably the easiest way for large scale tracking of things. It will record all SQL run against the database (you can limit it by user/login).