126 reputation
1
bio website
location
age
visits member for 2 years, 1 month
seen Jul 30 '12 at 15:19
stats profile views 5

Nov
21
awarded  Teacher
Oct
18
comment Windows Cluster - Can I failover without disturbing SQL?
MSDTC can also fail over without affecting SQL Server instances as it has its own IP, etc. Even if you are using distributed transactions, a distributed tran in progress would roll back upon failover. Most SQL installations to my knowledge do not use MSDTC, and it is just there as a default or to support SSIS.
Oct
14
answered Windows Cluster - Can I failover without disturbing SQL?
Mar
31
answered Will a SQL Server Replication Reinitialization overwrite data?
Mar
31
answered Diagnosing SQL Server 2008 Timeout After Prolonged Use
Mar
31
answered Access rights with Views