OCTom (12/1/2008)

---

The article referenced is no longer valid. A more up-to-date answer would be appreciated.

It seems to me that what was listed as the correct answer and the roll...

Chris Harshman (12/1/2008)

---

I thought the only thing that prevented a KILL from working was if the session was calling an extended stored procedure, was the same session that issued the...

bitbucket-25253 (12/18/2008)

---

Webrunner

I suggest you go to BOL (The link is in...

Brian LeBlanc-449582 (12/18/2008)

---

The premise of the question seemed to be “how to reduce the size of the snapshot?” and the answer is – Take another snapshot. I agree this...

Good question.

I don't understand why several people appear to thenk that the answer to "can you recover using the log backups that you do not possess" is not "no".

Nice clear question and answer.

Nice question.

I found it hard to work out an answer: a snapshot database can't be a shared scalable database - so presumably if I could take a snapshot...

Hugo Kornelis (1/6/2009)

---

Hi Steve,

Impersonation is a generic term for using the security settings of a user that you are not authenticated as. This term is used *both* for

(a) database users...

I reckon the second option is also correct - see http://msdn.microsoft.com/en-us/library/ms189811%28SQL.90%29.aspx. Access to a linked server may map a local login to a remote login, or use the local...

Mighty (1/7/2009)

---

For...

Nice question, I learned something (it's very easy me to learn something new about merge replication, as I've never used it).

I liked the question, and was rather surprised to see the comments saying that it's ambiguous.

I suppose that people have got so used to MS thinking they have...

It...

Good question.

I thought the "custom authentication" option was a nice touch, interesting to see how many people were tempted by it.

Maybe I should have done that - I might have been...