SQL_Surfer (11/17/2013)
Thanks. Any idea how to copy the list of linked server from 2005 to 2012? I didn't see the option in SDT.
You can script them out. You can either right-click on each one and script them seperately, or you can retrieve the info from sys.servers.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP