Sunday, June 26, 2011

List Server linked On Ms Sql 2005-2008

The Invent RDBMS was change everything in data storage, before the invent of RDBMS, a lot of IT implementator was use text file as data storage. But now they use Database as data storage.

one of the advantage using database management system as data storage is distributed data storage. Therefore
we must knew all the server that owned the database.

If you use Ms SQL 2005/2008

use this syntax to find how many server that linked to your server :
Select * from sys.servers

If you want to add linked server then use must use stored procedure sp_addserver for more detail to use sp_addserver please read help..

No comments:

Post a Comment