Browse by Tags

All Tags » Sql 2005 (RSS)

SQL Server Constants... The Constant Struggle..

Sql Server does not allow for user defined constants. So we are forced to take other routes like hard-coded values, scalar udf's, settings tables, etc. Unfortunately, all methods are not equal. You need to carefully consider your use of different...
Posted by Brian Rudolph | with no comments
Filed under:

MS DTC Configuration for SQL 2005 in a Distance-Cluster on Windows Server 2003 Datacenter IA64

As does everyone from time-to-time, we had a lovely "learn as you go" moment in the middle of a deployment recently. As it turns out there are some very specific rules for setting up MS DTC in a clustered environment. As always, individual results...