If I am not misreading the original request, I think you are trying to get multiple pseudo-identity columns in a single table.

This is a somewhat squirrely approach but it'd probably...

And for (future) reference-- looking at the execution plan should show they are identical.

jcrawf02 (2/19/2010)

I love that...

SuspicionBreedsConfidence**

**An ironic phrase appearing in the background in one of the greatest movies ever made, but in the context of a SQL DBA's life, a truism.

{hijack with apologies}

sing4you (2/17/2010)

Isn't this from "'Twas the night of the King's ....

Nine apathetic, sympathetic, diabetic old men on roller skates with a marked propensity toward procrastination and sloth

Is it safe to assume you will be relocating to Mount Olympus soon? Judging from your avatar it appears you're already appropriately attired.

a_solid_gold_kama_sutra_coffee_pot

(...you talkin' to ) Me?

Whoops. Sorry, forgot to include the code I used to derive my d'oh. When I re-ran it, it still comes up d'oh.

CASE

WHEN...

d'oh

Glad you like it.

By the way, my identity is not "SSC-Enthusiastic", just as yours is not "Forum Newbie".

Generally you should try to avoid using cursors in tsql-- with few...

You don't need a cursor; run this from the db you want to collect information on.

SELECT

sdp2.[name] as DBUser, sdp2.type_desc as DBUserType,

sdp1.[name] as DBUserRole, sdp1.type_desc as DBUserRoleType

FROM sys.database_role_members drm

LEFT JOIN sys.database_principals...

If/when you do this-- be sure you grab the...

This would NOT catch updates to a non-indexed table and it only has info since the last SQL restart, but if THOSE conditions were not game-stoppers, would this be a...