Wednesday, March 7, 2012

server transfer

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

No comments:

Post a Comment