Return Code Values Documentation for sp_send_dbmail procedure
I saw a question on MSDN forums today about return code values documentation for sp_send_dbmail procedure. Microsoft has not documented these return values to the user because when an error exists in the code the user will get a clear description about the error which is easy to understand hence they have provided only description for 0 (failure) and 1 (success). I’ll provide the list of return values and their description here, I’m sharing this since some of the developers will read this value and they can make use of it to get the reason for failure.
Configuring Alerts to Notify Policy deviations in Policy Based Management
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.
How to work with Policy Based Management (PBM)
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)
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 Copy \ Move a Database that is encrypted with TDE
In my previous articles on TDE I’ve gone through what’s TDE and how to configure it. Now here in this article I’m going to test whether I’m able to restore \ attach the database without encryption key since the main property of TDE is not to allow to use the physical files of the database without certificate. I’ll also brief about how to copy \ move the database that is encrypted with TDE.
Testing TDE without Certificate in the Instance
In the previous article I’ve encrypted the database TDE_Testing, lets try to use the physical files of this database with different methods to restore \ attach in another instance which doesn’t have this certificate and lets check whether SQL Server 2008 detects this.