I appreciate your answers. It explains why my transaction throws errors. we have SQL 2014 AG and it doesnt support DTC. I am trying to think a workaround. Thank you.

Thank you GilaMonster. I will check with apps developer.

They are set True. Will isolationlevel="repeatable read (3)"  cause deadlock? Thank you.

It is the table name in update statement. Tbl .

Hi Sergiy,
The table has 14835392 rows total and 23 columns. Col2 is clustered Primary key. Col and Col2 are integer.  no indexes on col.
indexes on the table
Col2...

I am not able to restore SMK from from primary to secondary when different service accounts are running. If both use the same service account I am able to restore....

Database master key is encrypted by SMK. It is set up according to MS Design. User database has DMK, symmetric and asymmetric keys.

Thank you. After i read your post, I solved the issue.

I changed the service account running SQL Agent to local services, restarted the agent.

Then change the local services back to...

Hi,

I am having the same issue. I am running SQL2016 on windows 2012 R2. The process could not be created for step 1 of job 0xD656A2765BDCF54F91F7D2CA16398CC3 (reason: A required privilege...

Thank you @Srikanth-562337. It solved my endpoint problem.

I have fixed it by rebooting the server and rerun upgradedlls. Thanks all.

I found the answer from the link.

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f4c858a2-992a-410b-97b4-8bf63ee5138f/maintenance-plans-gathering-information-from-msdb?forum=transactsql

;WITH XMLNAMESPACES ('www.microsoft.com/SqlServer/Dts' as DTS,'www.microsoft.com/sqlserver/dts/tasks/sqltask' as SQLTask)

SELECT

v.x.value('(@SQLTask:TaskName)','varchar(1000)') as TaskName,

COALESCE(v.x.value('@SQLTask:BackupDestinationAutoFolderPath','varchar(1000)'),v.x.value('@SQLTask:FolderPath','varchar(1000)')) as FolderPath,

COALESCE(v.x.value('@SQLTask:BackupFileExtension','varchar(1000)'),v.x.value('@SQLTask:FileExtension','varchar(1000)')) as Extension,

v.x.value('@SQLTask:DeleteSpecificFile','BIT') AS Del_Specific_File,

v.x.value('@SQLTask:AgeBased','BIT') AS Aged_Based_Del,

'DELETE backups older than '...

Thank you for your reply.

I looked select * from msdb.dbo.sysmaintplan_logdetail. I don't see Cleanup Task retention period.

Thank you for your reply.

I will want to write a poweshell script to retrieve a retention of Maintenance Cleanup Task from more than 80 SQL servers. If I know the...