I'm with Jeff. It's hard to maintain this and not necessarily any easier with an application writing to the tables than an XLS. Give the person with responsibility for deploying...

Honestly, the Upgrade Advisor should check some of this stuff. I agree with Jeff, I wouldn't drop them. Could cause lots of issues.

I'd develop a plan to execute them and...

sp_who2 is documented and can be used. Querying sysprocesses is not recommended.

You can kill them from SQL Server, but be sure this won't cause issues with the application. Some aren't...

You can build a DDL trigger for the login event and log the users that connect.

Some more info here: http://www.sqlservercentral.com/articles/Advanced+Querying/tamestrings2.asp/97/

Let us know what you think of them. I used Trancendors for my MCSE, but not the SQL stuff. They were pretty good.

Be sure that you practice with SSMS and...

Will the old data center be alive for some time, meaning will both be up?

If so, I'd really look at a Fed Ex schedule over a couple days to get...

I agree that your boss should give you requirements.

From there I'd search the web for similar apps using MySQL and then see about modifying them,borrowing code, etc.

If you have requirements,...

You can change the path for master in the startup for the service. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\ MSSQLServer\Parameters

Then you could start up, and then detach the others and attach them at the new...

How far is the new center? I'd really look at snail mailing or driving the full over, maybe then a diff from day 2 and go with logs to catch...

What kind of files? This is best done with other compare methods, not SQL.

Also, please post in the appropriate forum. It's been moved to the TSQL forum.

While I remember my own phone number, it's surprising how many others I don't know. Most of my friends are in the phone and I have no idea of what...

I'd use two different versions of the script, one for each SQL Server version, especially as the 2000 one might not work in 2008. Just return the same values so...

http://www.sqlservercentral.com/articles/Integration+Services/61619/

We don't have that, but we do have "Recent Post" above and "Active Threads" that show you what's changed since your last visit. With that you could log on, then...