I'm currently trying to replicate an entire SQL2000 database to another server. The distributer fails while trying to deliver the snapshot to the subscriber with this error
- Could not find server 'UKSQL01' in sysservers. Execute sp_addlinkedserver to add the server to sysservers. (Source: MSSQLServer, Error number: 7202)
The server UKSQL01 no longer exists, however it is still being referenced somewhere in the database i'm trying to replicate. I tried to create a linked server anyway with that name so there would be a reference in sysservers but that failed too.
Is there a way i can check all procs views and functions for references to this defunct linked server? Or a peice of software i can use to search for this reference in all objects? So i can remove it.