Linked Server ?

• madhu-686862

  SSChampion

  Points: 10707

  More actions

  August 5, 2009 at 11:07 am

  #140567

  Hi,

  We a have 2 SQL Server 2005 instances 'ins1' on Server A & 'ins2' on Server B. ins1 & ins2 are serving for 2 different applications.

  ins1 has ins2 as Linked server and through this Linked server ins1's application connecting to one of the databases 'Mydb' in ins2.

  Now we moved the database 'Mydb' to ins1 from ins2 and we do not need linked server and I removed the linked server. But the application is not working.

  What I have to do in order to make the application work after removing Linked server and Restoring the 'Mydb' to ins1?

  thanks

• JamieX

  Hall of Fame

  Points: 3763

  More actions

  August 5, 2009 at 11:17 am

  #1034975

  Is your application referencing it like server.database.schema.table???

  If so, you need to change your code where the table is referenced.