To expand, here's what I'd do:

Create table Logger

( myMessage nvarchar(max)

, DDLStatement nvarchar(max)

, UserName nvarchar(max)

, DatabaseName nvarchar(max)

, Timestamp datetime default (getdate())

)

;

Then I'd alter the trigger to insert data into...

If you want to know if a sysadmin has enabled SA, I would ensure an audit is in place, with logging to a file. Set permissions for your sysadmin groups...

Interesting. Are you Win2K? Or does the article apply to other versions for you?

I need to save that bookmark. It's a handy article.

What Lynn said.

Documentation is you need it: http://msdn.microsoft.com/en-us/library/ms184325.aspx

Powershell I've used:

$server = "dkrSQL2012"

$database = "AdventureWorks2008"

$query = "SELECT TOP 10 Document, FileName FROM Production.Document WHERE Document IS NOT NULL"

$dirPath = "C:\Users\Steve\Documents\Docs\"

$connection=new-object System.Data.SqlClient.SQLConnection

$connection.ConnectionString="Server={0};Database={1};Integrated Security=True" -f $server,$database

$command=new-object system.Data.SqlClient.SqlCommand($query,$connection)

$command.CommandTimeout=120

$connection.Open()

$reader = $command.ExecuteReader()

while...

Have you looked at monitoring replication?

http://msdn.microsoft.com/en-us/library/ms151780(v=SQL.90).aspx

Are the 30k rows recent ones changed/added in the publisher? are you sure there is no filtering taking place for this article?

You could use RG if you use a specific account/group for backups that you can fit into a classifier function. Read about that if you need to. This will potentially...

Is there some reason you cannot attach this to another instance? If it's because of possible corruption, please make sure you copy the MDF before attempting.

If you have potential data...

If Steven's link doesn't help you, post a sample XML document and some DDL. We can help you extract the data.

In 2008, you should have queueing. DB MAil uses Service Broker under the covers, so I wouldn't worry about that.

http://msdn.microsoft.com/en-us/library/ms190307.aspx

I do think Sean could be right that you have a...

SQLRNNR (4/8/2013)

I was down at the venue yesterday. I won't necessarily be at intersections....

rodjkidd (4/5/2013)

Steve Jones - SSC Editor (4/5/2013)

Cadavre (4/5/2013)

I'm in Castle Marina...

Run a trace in between the full backup and log backups. Capture things and look for any backup or truncate messages.

Something must be breaking the chain if this is not...

Part of the reason the KBs are there is to allow you to perform self-support. If you think that's not the case, or you are not sure you can solve...

Cadavre (4/5/2013)

I'm in Castle Marina Premier Inn, which according to Google...