This stored procedure takes the name of a remote SQL Server or a linked server defined on the local server and determines the status of it using SQL-DMO. Can be useful in log shipping scenarios or simply making sure all servers in a distributed system are available.