Developing Matt

My Technical Journal

linked server alternate setup to sql server

leave a comment »

There are different ways to set up a linked server, but if there is already a connection to a sql server with a linked server it is sometimes not a good idea to mess with the existing one.  Unfortunately you can’t pick Sql Server and add another one.  However you can still use sql server and just pick ‘other data source’ as below:

New Picture (1)

 

This will, of course, require you to reference the linked server name when calling out to your tables and whatnot…so I recommend you GET CLEVER.  A few suggestions:

Pickle Von Corndog 
Badonkadonnk
Ninjastar Dangerrock
Boo Manchu
Watts In A Name
Geez Louise
Dingleberry
Meepmeep
Porkchop
Mr. Pickles
Meatball

Advertisements

Written by matt

March 30, 2011 at 2:41 pm

Posted in Sql Server

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: