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!

Yes you can. It can be something like

exec xp_cmdShell 'del @File /Q'

/Q= Quiet mode, do not ask if ok to delete on global wildcard

There is no such rule as to whether CHECKDB or REBUILD should run first. Based on your requirements, those jobs can run in any order.

You cannot edit the Mail Content of the one sent by the Native Maintenance Task.

You can create your own SSIS Package and include Mail Task, in which you can...

You can use the Profiler tool to capture this information.

In "Event Selection" click "Show All events" and select "Audit Login Failed".

In-place upgrade is usually the better option. However, ensure to have good backups.

If the drive "Z" is still available, try to copy the contents of the DVD to the location specified in the error message

It can be achieved using the same logic. Here is an example

EXEC SP_MSFOREACHDB @COMMAND1 ='use [?]

if db_name()like ''%temp%''

begin

exec sp_helpfile

end

'

As seen in Wikipedia

The only known difference between .cmd and .bat file processing is that in a .cmd file the ERRORLEVEL variable changes even on a successful command that...

You can create a stored procedure for this code and use sp_MSforeachdb to execute it against each database.

Example:

EXEC SP_MSFOREACHDB @COMMAND1 ='SELECT DB_NAME(),DATABASEPROPERTYEX([?],'IsAutoClose''

I feel VARCHAR would suite this.

You may find the "Finding Specific Events Within a Trace" section in this article useful.