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
No comments yet.
Leave a comment
-
Recent
-
Links
-
Archives
- August 2009 (1)
- July 2009 (2)
- April 2009 (4)
- March 2009 (6)
- February 2009 (5)
- January 2009 (4)
- December 2008 (3)
- November 2008 (35)
- October 2008 (20)
-
Categories
-
RSS
Entries RSS
Comments RSS