In this article we are going to configure alerts for policy management. Alerts are triggered when a violation takes place in a particular policy that uses any of the three automated evaluation mode. Each of these evaluation mode will return an error number starting with 340*. You can use these alerts to notify either policy administrator or the database administrator who needs to make sure these values are under company standards. Upon receiving these alerts they can work with the user who has violated the policies or company standards. Error number for each of these evaluation mode is given in the below table.
Tag Archives: Administration - Page 5
Configuring Alerts to Notify Policy deviations in Policy Based Management
Posted by Vidhya Sagar
on March 22, 2009
Comments Off
How to work with Policy Based Management (PBM)
Posted by Vidhya Sagar
on March 21, 2009
Comments Off
In my previous article on policy based management I’ve gone through what is policy based management and how it helps administration. Lets discuss about how to work with policy based management i.e. how to create a policy and implement it. To work with a policy we need to first create a condition and we need to use this condition in our policy. Lets discuss each of the title mentioned below
- How to: Create a Policy-Based Management Condition
- How to: Create a Policy-Based Management Policy
- How to: Evaluate a Policy-Based Management Policy
Policy Based Management (PBM)
Posted by Vidhya Sagar
on March 21, 2009
Comments Off
Introduction:
Policy based management is one of the new feature added from SQL Server 2008. With the help of this feature you can evalute an instance or database or objects to bound with in certain conditions \ policies. If any of the objects or instances failed to bound with in the policy then it can either notified or you can directly change the values to bound within policy with the help of policy management there by making the administration simpler. So by using this feature you don’t need to outline all these conditions and no need to have an auditing on the same.
How to change Server Collation in SQL Server 2008
Posted by Vidhya Sagar
on January 19, 2009
No comments
New article posted on changing collation in sql server 2008. You can check the article from the link below.
In this article we are going to discuss about changing SQL Server 2008 collation at serverlevel. While installing SQL Server 2008 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling. Lets discuss the necessary steps for changing collation for sql server.
How to change Server Collation in SQL Server 2005
Posted by Vidhya Sagar
on January 12, 2009
No comments
New article posted on changing collation in sql server 2005. You can check the article from the link below.
In this article we are going to discuss about changing SQL Server 2005 collation at serverlevel. While installing SQL Server 2005 we may miss to choose the right collation and we need to rectify this by changing the collation at serverlevel. You can change the collation of sql server without uninstalling.