The way to stop deadlocks is to trace them down and then fix the code so it doesn't allow deadlocks.

Can I ask why the first column is a problem? Perhaps we have another way to do this.

Honestly any other way than dealing with this in the client is asking...

I'd use a batch file, and put the file names in there. You need to control ordering at times, so I'd be wary of a script like the one above.

http://www.sqlservercentral.com/articles/System+Development+Life+Cycle/vcspart3/525/

First, this isn't really a backup question. Please post in the correct forum (moved to admin).

Second, dbcc checkdb is a good place, but what do you mean by health check...

sleeping connections are still connected.

No one should show that db name in sp_who2. If they do, you need to remove them. That includes you connected with SSMS.

It's a communication issue. Can you give the names you used and are you sure the service is running on the 1st computer?

Is this a one time thing or regular? If it's one time, use the data export, and import, wizards.

You can use those if it's regularly, but I might suggest something...

Gail has the right idea. My Computer/Manage/Services, check for the MSSQLServer service and see if it's running. You can netstat-a and see if the listener is running.

Are you connecting locally,...

You can do this, but it's asking for trouble. It increases your surface area and potentially exposes you to sql injection.

The only thing I might do it read the "from"...

You wouldn't use shrinkfile to move data. It reclaims physical file space for the OS, does nothing to effect the data.

The problem is that unless you add data equally to...

How are the jobs running? You might check the client configuration utility for the default protocols.

Please post in the correct forums. Move to SS2K Admin

Mike has contacted me and should be sending me some code. Not sure if it's more than attached above, but I'll get it posted and drop a note in here.

Those numbers are likely falling. Given the recent banking issues, seems like we're getting less and less bank offers in the mail every day. Less stuff to steal.

As of now, no one really knows. I'm not sure if this is SQL 11 or SQL 10.5 right now.