Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
safzal1212
Starting Member
11 Posts |
 Posted - 2009-08-26 : 13:14:18
|
| I have two servers Pre Prod and Prod server. I want to update the status of records in a table on both the servers on any given time of the day. Actually the Query/Stored procedure will set the status of records to "Expired" if ExpiredDate=TodayDate on both of the servers. I also wanted to do it in one transaction so incase of any issue transaction could be rolled backed. Any suggestions what is the best way to do that? |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2009-08-26 : 13:54:45
|
| You can use replication or a linked server.An infinite universe is the ultimate cartesian product. |
 |
|
|
|
|
|
Data Update on Multiple Servers