Tuesday, December 4, 2007

How to find the status and information of connected servers in your MSSQL Server

How to find the status and information of connected servers in your MSSQL Server

Step 1

To find the information of servers connected to MS SQL Server, go to SQL Analyzer and then issue the following command

Exec sp_helpserver

It will reveal status of servers and replication connected to MS SQL Server.

No comments: