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 |
|
Radhika
Starting Member
15 Posts |
 Posted - 2001-07-06 : 14:58:41
|
| Hi all, my current issue involves with a stored proc that executes a stored proc on various SQL Server databases across WAN. The stored proc has a table which decides what all servers that it has to get the data from and dumps in a temp table and then passes the result to the crystal report over web. I have registered the servers as Remote servers and they give the desired results. Before executing the stored proc on the remote server i also check if that server name is available in sysservers table or not. By doing this way im avoiding the error for trying to connect to a remote server which is not configured. But the problem is that if someone manually stops the SQL Server database and start it over again, then MSDTC is not started which is the base for executing RPC. Then the reports gives an error. If i execute in Query analyser the error message displays MSDTC is not started on the abc server. Then i execute the xp_Cmdshell command to start the service on the server and if i execute the stored proc again there is no error. Is there any way to check if the MSDTC service is started or not in my stored Proc? |
|
|
|
|
|
Executing Remote Stored Procedures