Lots of time there's nothing I can do. App vendors want to sell software, not build the best quality they can. Deals get cut above my head, I just deal...

Me too? The application will send something to SQL Server, then it can delay or send a new query after xx sec.

Why use WAITFOR?

You can also use Excel and use OPENROWSET to read from it. I'd load it into a table so you don't have locking issues.

First, which version of SQL Server are you using? Is it 2000 or 2005? The reason I ask is that you posted in the 2005 forums, but Enterprise MAnager is...

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.