Pl. see the following example posted on ola's site:

EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',

@FragmentationLow = NULL,

@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',

@FragmentationLevel1 = 5,

@FragmentationLevel2 = 30

You need to put the database name in...

Good one, Steve.

Check following link which might help:

http://stackoverflow.com/questions/15112849/sp-send-dbmail-executed-from-job-fails-with-query-result-attached-as-file

HTH

Refer following Microsoft link which will help you to narrow down your deadlock issue:

https://technet.microsoft.com/en-us/library/ms178104%28v=sql.105%29.aspx

HTH

Yes, it will not change untill you do reindex!

Refer following article for further details:

http://sqlmag.com/database-performance-tuning/seven-step-process-changing-database-collation

check the following link might help if the issue is related to certificate/encryption:

https://connect.microsoft.com/SQLServer/feedback/details/207438/msx-enlist-failed-for-jobserver-servername

Yes, as described by happycat59 SQL SERVER instance have multiple collations. You can also change the collation to your desire using "Alter database" command. But one should know what settings/collations...

After you set up the log shipping any restore took place on secondary server? What is the recovery model of database?

Try editing registry carefully if any luck:

http://www.codeproject.com/Tips/278548/Install-SQL-Server-and-on-Same-computer

As per your requirement create a respective role for the application this will help you in easy maintenance of the security.

If you are able to recovery using repair_rebuild than it will be good as it do not have any data loss but possibilities are very thin. While using repair_allow_data_loss may...

Yes, I do understand but unless and until I/O test perform and result is out it is difficult to predict.

Thank you, Steve.

Good One, Thank you.

Yes, as W & M is not available all the databases on P will not be accessible. This is lost quorum situation as all 3 instances become disconnected from...