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 |
|
mohdmartin
Starting Member
22 Posts |
 Posted - 2007-06-22 : 09:00:20
|
| I want to create the procedure that when we restore the database backup few fields should not be updated from backup. ?table1field1, field2, field3,.......when restore the backup, from table1 of field2 should not beupdate ? how can create the procdures ?Martin |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-22 : 09:11:28
|
| I dont think that is possibleCreate a copy of that table and keep in other databaseAfter restore, copy that table to the restored DBThe doUpdate Oset col1=S.col1,col3=S.col3from Oldtable O inner join SourceTable Son O.keycol=S.keycolMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Procedure restore