Restrictions for create rule.
You can create a rule only in the current database.
Rules do not apply to the data that already exists in the database at the time the rules are created.
create rule statements cannot be combined with other statements in a single batch.
You cannot bind a rule to an Adaptive-Server-supplied datatype or to a column of type text, unitext, image, or timestamp.
sp_unbindrule objname [, futureonly]