What are you planning to automate ?

Thank You,

Best Regards,

SQLBuddy

1. IDERA SQL Compliance Manager

2. IBM Guardium

3. Oracle Audit Vault.

Thank You,

Best Regards,

SQLBuddy

What is the improvement measure for each of them ?

...

bindview (9/15/2011)

---

Results:

Primary_id - XXXXXX

primary_database - ABC

backup_directory - Networkpath

backup_share - Networkpath

backup_retention_period -...

Lets rule out some options..

1. Did you restore the Full Backup on secondary with NO RECOVERY option and is the secondary database in Restoring mode ?

2. Are the backups getting...

Use the Following :

CREATE A CONDITION USING THE FOLLOWING:

FACET : DATABASE

EXPRESSION:

ExecuteSql('Numeric', 'SELECT COUNT(*) FROM sys.database_principals a LEFT OUTER JOIN sys.server_principals b ON a.sid = b.sid

WHERE...

Good Job! Nice to know that ..

Thank You,

Best Regards,

SQLBuddy

Please check all the records.. You will find the comma at least in one field (usually description columns) and the data in the output file will display fine until...

Theory always looks fascinating. But things will be different when it comes to implementation and the intricacies remain hidden until issues arise..

The blog looks good but the important factor has...

Pouliot is right. If you have commas in any of the fields in the table , then the data will be misplaced in the output.

So try to replace commas with...

Make that local path a shared directory and enter it.

Thank You,

Best Regards,

SQLBuddy

Check this

http://www.mssqltips.com/sqlservertip/1523/how-to-setup-sql-server-alerts-and-email-operator-notifications/

Thank You,

Best Regards,

SQLBuddy

Check these resources :

http://www.brentozar.com/best-sql-server-dba-books/

http://www.sqlservercentral.com/Books/

Thank You,

Best Regards,

SQLBuddy

How are you testing the connection ?

In the SSMS, are you able to expand the nodes in the LServer and view the tables and other objects ?

Also did you check...

Did you assign a static port number to the Named Instance or is it using dynamic ports ?

As Aiello mentioned, check if SQL Browser service is stopped and start it...