Try to make use of TRY/BEGIN, CATCH in the trigger.

Also XACT_STATE can be used for rolling back.

Add an output file to the job step which should give you the exact output of the job. Also when the job is running forever, did you find any blockings?...

Hi Kemal,

Check if this post helps you.

Again, we see the WMI error "Error 80080005 occured executing request for EnumValues" everywhere.

Can you try if the below code as specified here helps?

%SYSTEMDRIVE%

CD %windir%\system32\wbem

Mofcomp.exe cimwin32.mof

Regsvr32 /s wbemupgd.dll

Regsvr32 /s wbemsvc.dll

wmiprvse...

You may choose your pick from the options available in Replication.

You can use the scripts mentioned in this[/url] article and set up a job which does server side trace.

Did the issue got resolved? Even I faced the same issue today and found that one SPID was blocking the Database Creation SPID. This resulted in the failure of DB...

Refer this article on MSDN

You can make use of the "Import/Export" wizard

Did you use sp_xp_cmdshell_proxy_account as explained here?

Also you may find this article useful.

Read the "Temporary Tables" section in this article.

Since you are issuing BEGIN TRAN before the table creation, when you ROLL BACK it...

Not sure your requirement of FULL memory analysis.

You can use DBCC MEMORYSTATUS

0x80041003 means Current user does not have permission to perform the action.

Can you...

In the same Maintenance Plan, create 3 three different clean up tasks (each for .trn, diff, .bak).

Hope this helps!