Can you force xp_cmdshell to open an elevated command window on the domain controller(s).

This is assuming that the OP is following best practise and has SQL installed on another server...

First off you need to ask why dont you have backups of your system databases?

Secondly this should help you out

http://blogs.msdn.com/b/sqlserverstorageengine/archive/2006/06/06/619304.aspx

I dont think it is possible in SQL to update LDAP as I have only ever seen it being selected from.

One option that could potentially work, would be to build...

Personally I would enable trace flag 1222 over 1204 as it captures more detailed information with the deadlock graph which helps to troubleshoot the commands in the deadlock. Makes...

Yes you would have to ask who the carrier is still but you save a hell of a lot of storage space in the DB.

Going off only ever using carrier...

blocks or locks?

sys.dm_exec_requests will show you who is blocking by the blocking_session_id

sys.dm_tran_locks will show you what locks are help against objects

Your wrapping it in a select

Try this, if not set eventdata() into a variable then use the variable in the insert instead of the eventdata() function.

--CREATE THE TRIGGER TO...

Yes if you write it manually.

MSDB.DBO.BACKUPSET, will tell you what was backed up, when it was backed up, who backed it up etc etc.

If you have a large environment I...

Wasn't aware of the take over, have to say I dont drink it quite as religously as I used to, switched more to the ginger beers like Crabbies and GingerBeard...

That file is the core of the actual SSRS web site, it is on the server already and gets modified by running the Reporting Service Configuration Manager tool on the...

The system tables in MSDB will help.

You will want backupset and the ones it links to, to generate the full picture

TDE might be a bit overkill if all your encrypting is the PAN, for that column level encryption would probably be the better choice to make on its own.

This might...

If you follow the link in my signature to the accidental DBA guide and read chapter 6 on blocking, that should give you some good starting points on the subject.

This could be a new side line business for Redgate, I'm sure that SQL Pun beers like that would go down very well with the community.

I have to take my...

Remove the /CommandText from the TSQL insert line.

should look like this

value('(/EVENT_INSTANCE/TSQLCommand)[1]', 'NVARCHAR(MAX)'),