Someone submitted an article recently that walked through how to find the rules in your database, which columns they were bound to, and then how to remove them in order to replace them with Check Constraints. It was interesting because it had been a long time since I’d worked with rules.
Actually I never used them in any databases I designed, though I did run into them with some third party products. For those of you not familiar, a rule functions like a CHECK CONSTRAINT, and determines what is a valid value to put into a column. You use sp_bindrule to link a rule (like a default) to a column. As that page says, however, rules are deprecated and shouldn’t be used.
In fact, they ought to be replaced with check constraints, which function in much the same manner. It’s fairly easy to do, although determining where the rules are bound isn’t. Look for the article soon at SQLServerCentral.
And start replacing those rules with constraints. It will save you some work down the road as likely SQL 11 or SQL 12 won’t upgrade with them.