Update a table from a different database in SQL Server

If you want to update a table from one Database Server to other, then you just need to refer to the table as LinkedServer.DatabaseName.SCHEMA.TableName But make sure they are on the same network... Here's an example: Lets say your Database name is Naveen_AU and has a table called tblSearch on jxt-ws01 Server then you can access that table asĀ [jxt-ws01].Naveen_AU.dbo.tblSearch
UPDATE [jxt-ws01].Naveen_AU.dbo.tblSearch
      SET IsSubscribed = @IsJobAlertSubscribe
WHERE searchID = @searchID
PS: I have tested this in SQL Server 2005 and it works, it should also work in SQL Server 2008