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 |
|
nixxerebb
Starting Member
2 Posts |
 Posted - 2009-05-15 : 23:42:58
|
| I have a database with a certain table structure that collects computer inventory information.. The database can accept metadata when an inventory value is passed to the server..The problem, is if there is a network glitch, or something that causes a corrupt table name (ex: 'so]ftware' instead of 'software') the new metadata will be created as a new table header 'so]ftware' along with the old, correct one... I'd like to be able to lock the database to preserve the integrity of the tables, and unlock only long enough to allow a new value to be added. Any ideas about methods to do this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-16 : 03:32:44
|
| seems like what you're looking for is DDL triggers. |
 |
|
|
nixxerebb
Starting Member
2 Posts |
Posted - 2009-05-16 : 08:50:43
|
| Thank you, I will look into that (Google) as my fix.. Do you know of some examples or good locations for learning how to implement?What I'm looking for is a way I can 'lock' the tables for 99% of the time, unlock the DB so an incoming value would add a correct metadata table, then relock the DB.. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-16 : 14:44:26
|
| http://www.developer.com/db/article.php/3552096 |
|
|
|
|
|
|
prevent structure changes