Does anyone know the most efficient way of transfering linked servers between databases with out manually recreating them?
I can't seem to script them, I looked into the sysservers table, I don't want to insert into a system table until I have to?
There has to be a better way, has anyone run across this in SQL 2000?
Thanks
Hi,
All are kept in sysservers system table both in sql2k and sql2k5
select * from master.dbo.sysservers where isremote = 1
