kwoznica (5/1/2012)
thanks OPC I'm going to put this on my test server now. I'll let you know how it turns out.
I tested it locally on a 2008R2 instance. Please post back your findings. Thanks.
by the way why do you put the () after ORIGINAL_LOGIN() as if its a function?
I have to...because it is a function. ORIGINAL_LOGIN (Transact-SQL)
This works:
SELECT ORIGINAL_LOGIN()
This throws an exception:
SELECT ORIGINAL_LOGIN
[font="Courier New"]Msg 207, Level 16, State 1, Line 1
Invalid column name 'ORIGINAL_LOGIN'.[/font]
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato