Many thanks mchevallier! I lost a lot a couple of hours in this issue.

Can anyone confirm this is working on SQL Server 2008 R2 please?

Tested in SP2, CU #5, and the results are negative, the parameter values are not shown in SQL Server...

Hi Old Hand,

Most probably your user is sysadmin, or has CONTROL SERVER access. Try without these - it won't work! laker_42 is right!

...just to add that the syntax for the login in fact completes successfully:

use master

go

GRANT IMPERSONATE ON login::[domain\Security Group] TO [domain\User]

go

but then, when launching EXECUTE AS to impersonate an individual login,...

Hi Gordon,

Unfortunately, this is not possible currently in SQL Server. SQL Server (for some reason) cannot read members out of the AD group configured as a login in SQL Server...

Worked like a charm with "Offline" mode!

I had a interesting situation: my database was in Warm Standby mode, and I had a .tuf file deleted. The releiving thing was that...

Back to the issue SSC Veteran reported on the second post of this topic, I had the same experience - lost my 2 day work after an autorestart during weekend,...

arbcoll (5/12/2011)

---

The script can be useful, but it does not return any row from my deadlock XML graph. What could be the reason?

****

I just found the reason: just removed the...

The script can be useful, but it does not return any row from my deadlock XML graph. What could be the reason?

****

I just found the reason: just removed the <TextData>...