Here is a script to get a full blown audit of security

http://jasonbrimhall.info/2010/03/19/security-audit/

It's beyond what you requested but will cover all of the bases.

Another script I saw recently is here that...

They should still display a database name. With no activity on the server, all of my instances still show a database name for those spids.

I think it must be...

Robert klimes (2/7/2014)

---

Jeff Moden (2/7/2014)

---

My problem is that I'm still stuck with 2005 at work (apologies for forgetting to mention that on a 2K12 forum). CMS isn't possible for...

TURN

Ed Wagner (2/7/2014)

---

L' Eomot Inversé (2/7/2014)

---

Jeff Moden (2/7/2014)

---

Koen Verbeeck (2/6/2014)

---

Steve Jones - SSC Editor (2/6/2014)

---

However, this way they can give feedback that something worked. We are talking about how to...

Confidence

Intriguing question

Jeff Moden (2/7/2014)

---

My problem is that I'm still stuck with 2005 at work (apologies for forgetting to mention that on a 2K12 forum). CMS isn't possible for me at...

MyDoggieJessie (2/7/2014)

---

Hey everyone! It's ugly code Friday!!! :hehe:

Here's the ugliest way around the issue (as pointed out by SQLRNNR)D-ECLARE @String varchar(250)

SET @String = 'xxxdb_backup_2014_02_06_073328_1849272.trn'

SELECT LEFT(@String, CHARINDEX('_', @string, 7)) + REVERSE(SUBSTRING(REVERSE(@String),...

jasona.work (2/7/2014)

---

SQLRNNR (2/7/2014)

---

Kinky??

Um no. Just got back from SQLCruise with Grant and nobody...

Jason Carter (2/7/2014)

---

I believe the best answer to this is the classic

One bite...

call.copse (2/7/2014)

---

That is definitely one to have mapped out in advance. I'm British and so really awkward about that sort of...

Kinky??

Um no. Just got back from SQLCruise with Grant and nobody wants to...

GilaMonster (2/7/2014)

---

Koen Verbeeck (2/7/2014)

---

GilaMonster (2/7/2014)

---

Koen Verbeeck (2/7/2014)

---

Ed Wagner (2/7/2014)

---

That's one thing I really enjoy about SSC. The people here aren't paid to answer questions. We do it because...

inoculation