Dead Locks

DeadLocks Information:
http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=Troubleshoot%20Deadlocking%20in%20SQL%20Server

Remote Server Administration Tools for Windows 7

Remote Server Administration Tools for Windows 7 Installation:
http://www.microsoft.com/downloads/details.aspx?FamilyID=7d2f6ad7-656b-4313-a005-4e344e43997d&displaylang=en#filelist



Once Installed the Remote Server Administration Tools for Windows 7, then

Follow below steps

For Window7 64 you have to install the amd64fre_GRMRSATX_MSU.msu

Start menu->Control Panel-> Programs -> Turn Windows Features On and Off -> Check all the Administrative tools Options or Remote Desktop Options

SQL Server Product Information

Objective:
The below query information retrieve your servername, sql server edition, Product Level like Service Pack version and Product Version number as well

Query:
select @@servername as ServerName,serverproperty('edition') as Edition,serverproperty('productlevel') as ProductLevel,
serverproperty('productversion') as ProductVersion