Ebeworld’s Weblog

Trying to create

Distributed query.

Add server info
EXEC sp_addlinkedserver [servername]

Add login to the server:
EXEC sp_addlinkedsrvlogin @rmtsrvname =[servername], @useself = ‘false’, @rmtuser = ’sa’, @rmtpassword= ‘Dell@123′

check it using sys.servers or directly in SSMS

March 23, 2009 - Posted by ebeworld | Uncategorized | | No Comments Yet

No comments yet.

Leave a comment