asked
updation of tables in 2 databases at a time
hi every one , i am having 2 databases in windows 2003 server using SQl 2005 i want to update a table which was same in both databases a column needed to be updated . can i open the databases staying in the masters Query window only if i open this two databases at a time and update the column in both databe tables then that will be great. can any one have the command to do this please provide me the solution for this. Thanks in advance....
Is this what you are seeking? UPDATE db1.dbo.TableA SET colA = 'Me' WHERE id = 1 UPDATE db2.dbo.TableA SET colA = 'Me' WHERE id = 1
Excellent solution Jonlee you have saved me in the right time when i was exactly lacking this command and it worked thanks a lot for giving this command.
Hi , You need to provide the fully qualified name . DatabaseName.TableName example: select * from AdventureWorks.dbo.DatabaseLog
Also, as has already been pointed out, there is no way to do these "at the same time." You will have to fully qualify the table name and run the updates in sequence, but to get them to be at the same time, you need to wrap them in a transaction and then commit that transaction. Otherwise it will be one, then the other.
