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 |
|
san79
Starting Member
42 Posts |
 Posted - 2008-04-03 : 01:52:36
|
hi thanks for the help you guys given me on trigger thread, nowi would like to create a rule for my database, the rule is used to check the status ="Alive" , i am having status as a common field for my department table, designation table and group table. if the records which is having status="Alive" should only be allowed to inserted in the employee profile table, say while inserting if the department is closed i.e. the status="C" then it should not get inserted, as most of the tables have status as common field i would like to set it as a rule, is this a good idea , can any one predict any pitfalls in future, like it may harm the report data or any thing else,  thanks for your help |
|
|
san79
Starting Member
42 Posts |
Posted - 2008-04-04 : 01:18:35
|
| come on members , is no one here interested in this topic. |
 |
|
|
|
|
|
requesting comments on rule