Link to home
Start Free TrialLog in
Avatar of Sonia Bowditch
Sonia BowditchFlag for Guernsey

asked on

t-sql sp_addlinkedserver possible risks

Hello Experts,

I have been away from working this deeply with SQL for a number of years and I am possibly being a bit too nervous about creating the linked server.

I am using MS SQL 2016 and it gives an easy graphical process to create the linked server.

The problem I am experiencing is if I create this link could it cause issues with the live servers and databases I am linking?

Thanks,
Infosec36
ASKER CERTIFIED SOLUTION
Avatar of Pawan Kumar
Pawan Kumar
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Sonia Bowditch

ASKER

Thank you.  I will get the linked server set-up now.
Avatar of _agx_
>> could it cause issues with the live servers and databases I am linking

Do a search on possible issues with linked servers first. They're easy to set up, but like anything else, they have pros and cons. Performance is usually the biggest "con".  I'd recommend fully researching them first to determine if/how the "cons" apply to your situation.

http://dba.stackexchange.com/questions/40184/linked-server-risks