July 3, 2009 at 3:45 pm
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.
July 29, 2009 at 5:42 am
Which Facet are you using the 'Table' or 'Table options' one. I think 'On change prevent' might only be available with the table options facet.
July 29, 2009 at 7:27 am
Im using the tables facet. Il give the table Options facet a go and let you know how it goes. thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply