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 |
|
nuclearsiloman.com
Starting Member
2 Posts |
 Posted - 2008-10-03 : 16:41:02
|
| I have a 100 table database that had the constraints and column defaults removed - but the data left intact due to a hack. I have the sql script that originally built the database.Is there a way to script the existing constraints/column defaults from a duplicate database (or script I have) and apply them to the hacked database thus restoring it to operating condition and keeping the valid data it has?Thanks. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
nuclearsiloman.com
Starting Member
2 Posts |
Posted - 2008-10-03 : 16:43:56
|
| Great. So my next question is... is there a way to create a script off the good database that I could then run on the hacked db? Maybe through Enterprise Manager?It was hacked - I had ~12k injections in it that I had to purge. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Re-applying constrains & defaults