.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Policy based management missing evaluation modes

Posted By:      Posted Date: October 25, 2010    Points: 0   Category :Sql Server

For some reason, I only get the on demand and on schedule evaluation modes with my instance of SQL server, what is even more suprising is the fact that i am following a step by step guide and the guide seems to have the on change log only evaluation mode.

Is this a bug or something ?

I am using SQL 2008 SP1 developer edition, I get the same issue even on my standard edition.

View Complete Post

More Related Resource Links

using policy based management to exclude database access

After reading information on the link http://www.mssqltips.com/tip.asp?tip=1492 I was wondering whether its possible to have a policy in place such that database A cannot make reference to objects in database_B, I am guessing that one would have a policy such that the contents of the objects must not be like %database_B.%   Let me know whether there is a better way to do this. Thanks.

Policy based management : what rights do ##MS_PolicyTsqlExecutionLogin## need

Hi, In order to run Policies on scheduled basis, what permissions should I grant to ##MS_PolicyTsqlExecutionLogin## login? Problem is: When I evaluate the policies myself, they dont fail, but when I schedule them, they fail reporting ##MS_PolicyTsqlExecutionLogin## login doesn't have access to <> database. Any help please?

Policy-Based Management and On Change - Prevent




I’m working on Policy-Based management feature and I’m keen to implement some of the features. I tried to setup a Policy for a “backup device” facet based on the condition that the name starts with bkd_. I tried to set the evaluation mode to “On Change – Prevent” but unfortunately I could not find the mode at all in the Policy Screen. I also made sure the “Nested Triggers” advanced Option is set to 1.


I went through this  link http://blogs.msdn.com/b/sqlpbm/archive/2009/04/13/policy-evaluation-modes.aspx and checked for the execution_mode in  msdb..sysp

SQL Server 2008 R2 Enhancements to Policy-Based Management


I'm reasearching enhancements which have been made to Policy-Based Management in SQL Server 2008 R2.  I"ve found several articles and posts on PBM in general, but nothing that explicitly describes what enhancements have been implemented in SQL 2008 R2 which are not available in SQL 2008.  Does anyone know of any white papers or articles which discuss this?

creating a code based on the evaluation


I would like to create a simple program, like a game, but so far without any graphical interface. Only a code, supported with some numbers, so that the user will know whats going on in the background.

I was thinking of creating a racing game (like formula 1 or sometihng similar), with available data (attributes) like:

Driver: age, agility, concentration, experiance, stamina,...

Car: engine, chassis, tyres

Bug Tracker: Build a Configurable Web-Based Bug Management Tool Using ADO.NET, XML, and XSLT


One of the most significant features of ADO.NET is its integration with XML. Developers can either use an ADO-like API to access the data or work directly with an XML representation of the data. This article demonstrates how both of these techniques can be used together to create Web applications that take advantage of XML standards such as XSLT. The example presented here is a bug tracking application built using C# and the.NET Framework. The development of the application covers several topics including data access using ADO.NET, the presentation of data using XSLT stylesheets, and the integration of ADO.NET with the .NET XML Framework.

Roy Margolis

MSDN Magazine July 2002

SQL Management Studio Missing

Only configuration tools appear under Sql Server 2005 start menu. Cannot install client components as they appear to be installed already. Applied service packs 2 and 3. I'm installing 32 bit sql server 2005 on windows 7 professional 64 bit. Please help with details.

Information Policy options missing?

I've set up a Content Type Hub to allow me to publish content types to all site collections. However, doing this appears to have removed the Information Management Policy Settings link on the settings page for the content type. Does this mean that you can't set IM policy on Published Content Types?  

Session management modes

Why Session_OnEnd does not fire in state server & SQL Server modes....... i mean what is the speciality in InProc mode that Session_OnEnd fires in that mode only ????? 

Information Management Policy - Expiration not working

I've defined a new policy for my list.
The policy has expiration enabled.
The expiration date is WarningDate (required list field - date and time) + 0 days and the expiration should trigger the custom workflow, which would send the warning, but is now only setting the status to Warned.
The workflow works fine when executed manually, but never seems to be actually executed by the item expiration.

I've also updated the "information management policy" job to run every 5 minutes, but it didn't help.
What as I missing?

Policy Management ensure a table name is in the index name

I am trying to write some policies to enforce our coding standards.  One of the standards we have is to prefix indexes with IX_<tablename>; the IX_ is easy to do with the index facet.  How do you access the tables name in the condition?
Thanx, Adam

How to create a condition and policy to deny access based on host name



With SQL Server 2008 Enterprise, can I prevent an Active Directory Account Login ( domain\user ) from connecting if its coming from a host_name?

What I really need to do is this:  


On SQL1, login mydomain\user1 is only allowed to login from servers APP2, APP3, and APP4.


If mydomain\user1, though it has a login on SQL1 attempts to connection any other hostname besides APP2, APP3 or APP4 I want to deny it access to SQL1.


Can anyone point me in the right direction for the correct condition(s) for a policy that would work?



Erik A. Grob, MCITP, MCDBA

SQL Server 2008 Management Studio - "Show policy health state for all nodes"

What does "Show policy health state for all nodes" option do in SQL Server 2008 under the Object Explorer?

Screen Shot

Policy Evaluation Mode On change: prevent and On Change: Log Only not available


Hi All,

I am creating a policy to ristict Developer to use definied naming convention for stored procedure , but i am not able to see Policy Evaluation Mode  On change: prevent and On Change: Log Only.

Please let me know what is the problem.

i have checked the sp_configure option nested triggers and server trigger recursion is enabled.


Mohd Sufian www.sqlship.wordpress.com Please mark the post as Answered if it helped.

Policy Management - Use of ExecuteSQL() for Index facet to define naming convention policy


I am trying to define an advanced policy involving use of executeSql() function and @@SchemaName, @@ObjectName parameters. It is related to non-clustered index naming convention and as such I am making use of 'Index' facet.  I have defined policies for tables and procedures and I have successfully used executesql with @@SchemaName and @@ObjectName parameters. However, when I run Index policy I get the following error;

TITLE: Microsoft SQL Server Management Studio

Exception encountered while executing policy 'CompanyName - Index - Naming Convention'.

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtSrc=PolicyEvaluationException&LinkId=20476


Must declare the scalar variable "@@SchemaName". (Microsoft SQL Server, Error: 137)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft&#

SQL Server 2005 64bit Install - Missing Management Studio


Good Afternoon,


I just installed SQL Server 2005 64bit on a fresh system with no other applications loaded on running on the new server.


The only other component that was installed with the SS2K5 database services is SSIS. The base installation and the SP2 patch went on perfect.


I went looking for the Management Studio thru the Start menu options and it is NOT under the Microsoft SQL Server 2005 group. The only options under the SS2K5 group are "Configuration Tools" and "Docs and Tutorials".


Here are file names that I downloaded from the MS website and installed.


   SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #1 x64 MLF.x11-57796 (which is a zipped)




There was also another zipped file that I tried to install but it seems to be a duplicate of the zipped file above:


SW CD SQL Svr Enterprise Edtn 2005 64Bit X64 English #2 x64 MLF.x11-57797


Any help would be greatly appriciated.


Thanks ALL!


J Kusch

Information Management Policy & Disposition Workflow


I would like to set an information management policy that enbles expiration of documents in my document library. I then want this to kick off a disposition workflow that will then allow the owner of the content (i.e. the last person to modify the document, or creator if it has not been modified) to either delete the document or do nothing. This is all simple to do. My question is: When the disposition workflow kicks off, does it send an email to the document owner or does it simply ceate a task in the specified task list?


If it only creates a task, is it possible to notify the document owner that a task has been created? I don't want docment owners to have to have to keep checking the task list, I want an email sent to them whenever a document is about to expire. Is this possible?

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend