Hi,

You can utilize the following steps:

1. Create your conditions which you want to evaluate.

2. Create a second condition that makes use of the "Database" facet. In this condition, you should...

Hi,

1. Open Visio 2010 with credentials that is able to connect to the database.

2. Select the Database diagram template.

3. Go to the database tab and select reverse engineer.

From there on...

Hi,

The easiest way to find this out is to check out the default trace. The catch however is to do this as quickly as possible after the permissions changed due...

Hi,

You can execute the following command:

SELECT NAME,log_reuse_wait_desc FROM sys.databases

This will tell you what the log is doing i.e. replication, T-Log backups, etc.

You can also read my post on VLF's here.

Pleasure.

Well it is best practice in regards to security to run the SQL services with a domain account.

The reason it works now, is because it is running under NTLM authentication...

Hi,

I played a bit with the code. The "enable" policy is only valid if you schedule your policy or if are looking at settings which can be set for On...

Can you please provide the details of the policy which you created?

No,

They are exactly the same with only the expiration date added.

Evaluation is to "test run" SQL server to see if it will meet your RDBMS needs, there for it has...

Hi,

This problem can have two root causes.

1. The server is not set up for using kerberos authentication and there for cannot complete double hopping.

2. The SPN is incorrect for the...

It's a pleasure, that's why we are here 🙂

Hi,

To my knowledge, service packs for SQL 2005 cannot uninstall, however the ones for SQL 2008+ can be uninstalled through Control Panel.

Hi,

You can add the user to the database with no roles assigned;

Then go to Database >> Security >> Users; right click on the user >> properties; select securables>> click...

We have run into the exact problem. Some of our virtualized servers (OS 2003 and SQL 2000) refuse to run on the X series server processors in our VM hosts,...

Hi,

I got my SQL 2008 certifications last year. Apart from a huge enivornment to gain experience from; the best I found was to read and self-study. To write the tests...

I was in the same boat as you regarding XML when I started using Policy Based Management and XEvents...

Bought the following book and studied it in conjunction with googling.

APress Pro...