Hello I got a nice one.
I have 2 MS SQL 2000 databases on the same server both are almost alike.
Both have an items table with the field searchcode
I want to copy the searchcode from db1 table1 to db2 table1.
So something like this:
use [db1] select itemcode,searchcode from table1 use [db2] update [db2].[dbo].[table1] values ( select itemcode,searchcode from [db1].[dbo].[table1] )
Only this code doesn't work!!!!!!!!!!!!
The itemcodes are equal in both tables!
I want to schedule this to run every night.
This is just an example, but if I can do this, only 1 database needs to be maintained and the other database gets updated every night!
Anybody any ideas?
Thanx for any replies!