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 |
|
ujjaval
Posting Yak Master
108 Posts |
 Posted - 2005-12-19 : 22:30:13
|
| I have say about 23 tables. I have a column with foreign key reference to all these tables from a primary table. I am updating primary key values values with all new values that also gets updated in all other tables. Although this sounds not a good question, but is there any good way to verify the database after I update all the values in the primary key column of primary table?? I mean all the updates are correct and no orphans left or no incorrect updates occured??thanks,Ujjaval. |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2005-12-19 : 23:08:45
|
| hi ujjavalonly way I can think is to keep a copy of the original keys in both the primary and foreign tables (ie create a new column called OldKey)then you could run some queries to check that the new keys return the same records as the old keys (and recover if there is a problem)--I hope that when I die someone will say of me "That guy sure owed me a lot of money" |
 |
|
|
|
|
|
database update verification