Random thoughts and bits of Software Dev Knowledge: How to create a linked server from a local SQL server instance

Monday, May 23, 2011

How to create a linked server from a local SQL server instance

I needed to add my local server as a named linked server on my development workstation.
Here is the magic hand shake...

--local linked server
EXEC sp_addlinkedserver
@server='FUSIONRIS',
@srvproduct='',
@provider='SQLNCLI',
@datasrc=''

No comments:

Subscribe to: Post Comments (Atom)