Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pattikay
Starting Member
36 Posts |
 Posted - 2002-08-26 : 06:27:32
|
| Hi,I am am writing a stored procedure that gets details about certain databases on different servers.However,some of these databases on that list may have been deleted or may not be available for one reason or the other.Hence I recieve the error "MS DTC on server '%.*ls' is unavailable."Is there a way of finding out whether the MS DTC on a machine is available or not using T-SQL so that the stored procedure may move on to the next database without exiting the stored procedure? |
|
|
|
|
|
MS DTC