Im going through a walkthrough of creating policies for sql 2008. The walkthrough is located here:
http://www.mssqltips.com/tip.asp?tip=1492
Im creating one that prevents users creating tables with names beginning wiht 'tbl_%'
I create the condition, then go to create the policy. i give the policy a name and set it against every table in online user databases.
The tutorial then tells me to set evaluation mode to on change-Prevent but that is not available. all that is available is on demand and on schedule.
Am i doing something wrong here?
EDIT: the Enabled check box is also greyed out.