Perhaps this will help:

SELECT

a.publisher_db,

a.article,

ds.article_id,

ds.UndelivCmdsInDistDB,

ds.DelivCmdsInDistDB,

CASE WHEN md.[status]...

Sounds suspiciously like homework...

The software needs to be registered using your proxy account that is used for the SQL Agent. You know how when you install some new software on the box,...

A silly question I'm sure but is your desktop a member of the same domain? Or are you getting an error? i.e. (Cannot generate SSPI context?)

Thanks Lynn, got what I needed from there (not sure why my first couple Google searches didn't find that) - appreciate your help!

Users who have the SHOWPLAN, the ALTER TRACE,...

Christian Buettner-167247 (2/21/2013)

---

Nice question, but the explanation lacks important information. Let me quote it for you here:

Table Hints (Transact-SQL) - SQL Server 2008 R2

---

WITH ( <table_hint> ) [ [...

Scratch that, I guess there's no real way to tie the statement back to a user :crazy:

I believe that's correct. But depending on how long ago it happened the statements used might still be in the sys.dm_exec_query_stats DMV?

EDIT: I meant the sys.dm_exec_sql_text DMV

I don't believe this is possible unless you already have Change Data Capture running

There is nice app from ApexSQL which can be used as a trial and literally and visually...

Pretty easy to change, however I'm not 100% certain you'll need to restart the MSSQL service in order for it to take effect (check BOL)

Right-Click on your SQL Server instance,...

It is no different than sending any other file. If you aren't comfortable with the command-line...

You can set up alerts under the SQL Server agent, I believe the type is "SQL Server Performance Condition Alert" and it will allow you to set thresholds for each...

From my point of view walking into a new company as a "new" DBA is a intimidating task. As you can tell from the answers (good ones) provided here,...

Yes you can FTP the backup (I believe you'll need to use the "bin" flag), or burn it to a DVD or other storage media and send it via courier?

The default SQL Server trace runs in the background and is...