Great catch SSC.

SELECT

ProductID,

SUM(LineTotal) OVER (PARTITION BY ProductID) [ProductTotal]

FROM Sales.SalesOrderDetail

WHERE ModifiedDate = '07/31/2008'

Hi,

I ended up using PowerShell to create the DTC and was able to name it.

# Create MSDTC Resource

Get-ClusterGroup 'SQLServer(DB01)' | Add-ClusterResource -Name 'MSDTC-SQLServer(DB01)' -ResourceType "Distributed Transaction Coordinator"

Also, someone suggested...

Since you're on XP and using SSMS 2008, here's the file you should be looking for:

C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin

To find the version of SSMS, open SSMS, go to Help, then About.

What version/edition of SQL Server Management Studio are you using?

If you are using Vista or Windows 7, it will be located here:

C:\Users\<username>\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell

Unfortunately, it's an all or nothing solution. Here's a reference:

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/21e91e52-1e9e-4a7a-8636-aed4227fe9e7

Unfortunately, yes. I've been a victim of this.

Also, make sure you get a RAID Controller with Write Cache.

Enable Trace Flag 1204:

DBCC TRACEON (3605,1204,-1)

This will enable all deadlocking info to be written to the SQL Server Error Log which should provide you with the info you...

Actually, SP1 is 9.0.2047.

9.0.2153 is SP1 + K918222 Hotfix.

But, you can manage your SQL 2000 Instances in SS Management Studio.

Tim

Try using xp_regread, such as:

declare

@rc int,

@dir

varchar(5)

exec