Don't care. My resume should be always updated. That's prudent. It doesn't imply or mean I'm looking for...

The "inserted" table contains the new values. The "deleted" table contains the old ones. Change that, or add more code if you need both.

The point isn't that climate change/warming/whatever is true or not, but rather that MS Research is trying to tackle the difficult problem of building models, and providing tools that can...

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