April 2, 2012 at 6:20 am
Can some one let me know what are the Policy Base management's? If you can please send some sample policies with scripts Possible?
Can you any body please list out some policies in sql server.
April 2, 2012 at 6:49 am
http://msdn.microsoft.com/en-us/library/dd938891%28v=sql.100%29.aspx
I would read this document than ask any questions which you dont understand.
Top level overview would be you have a set of Facets, which are used in Conditions, which are used in Policies.
Say I want to create a policy which ensures that all stored procs are created in the DBO schema
I would create a condition on the stored procedure facet, using the schema property giving it = 'dbo'
I would then create a policy which enforces the condition using on change prevent to stop people from creaing Stored Procedues in schemas other than dbo
April 2, 2012 at 7:24 am
By default SQL Server comes with a whole bunch of Policies built in. To try them out, right click on the Policies folder and select Import from the context menu. Drill down on the folders and you'll see different policies that you can try out.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply