Express doesnt come with an agent.

Granted it looks like an agent is installed in services.msc but this is a bug with the install in 2008 and as such the agent...

Printing is not supported in Firefox, it is listed on the browser support page for SSRS

http://msdn.microsoft.com/en-us/library/ms251673%28v=vs.100%29.aspx

If you want to use full functionality SSRS needs to be run in IE.

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.