Preemptive is a non-cooperative, which generally happens with processes that are running outside SQL.

This is not good for SQL Server as it is a particular external process which makes...

Partition Switching will fail as the Main and Switch Table should be identical(not just no. of columns but also their properties).

"sp_rename" is a safe option.

Is this for experimenting or an actual request?

Is the remote server a named instance? If so, specify the port number on which the named instance is configure and follow the Linked server config process

Most of the time the cause for deadlocks/blocking is within the code. The concurrency issue can be solved after a review of the code and maintaining transaction/isolation based sessions.

I'd suggest to verify your SAN / DASD disk subsystem

Try this....

http://www.mssqltips.com/tip.asp?tip=2061

worked for me!

My apology guys.

The example provided makes the question confusing.

It can display the drive letter...

Chk this out for the Win32_Volume WMI Event

http://www.it-visions.de/Scripting/WMIReferenz.asp?C_Klasse=Win32_Volume

Your Script Looks much more formatted!

Thanks again for clicking my first article!