Basic debugging needed here. Please do this first.

create table logger

( Body varchar(500)

, Subject varchar(104)

, Name varchar(100)

, Version int

, Timestamp binary(8)

)

Use this to debug your trigger.

Then set the trigger like this:

ALTER...

Yes you can, no it isn't expensive.

We have a couple articles on building clusters virtually:

http://www.sqlservercentral.com/articles/virtual/72682/

http://www.sqlservercentral.com/articles/Clustering/73989/

http://www.sqlservercentral.com/articles/Clustering/73994/

Matt Velic has a great piece on cheap ways to do this as well: http://mattvelic.com/virtual-lab-companion-ebook/

We have...

I would again suggest you revisit this idea. It's easy to lose emails, and potentially miss auditing issues here.

If you want to capture this, I would say you should insert...

That link is incorrect. Bug submitted to Connect: https://connect.microsoft.com/SQLServer/feedback/details/783547/implementing-endpoints-documentation-is-wrong

L' Eomot Inversé (4/12/2013)

---

Interesting question. Of course none of the answer options is actually correct because the all say TCP where they mean T-SQL but that won't confuse anyone.

It's...

Lynn Pettis (4/11/2013)

---

Yes,...

L' Eomot Inversé (4/11/2013)

---

Jan Van der Eecken (4/11/2013)

---

Dunno, but it really looks like he was dumped into getting this job...

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...