February 10, 2016 at 11:42 pm
This was removed by the editor as SPAM
February 10, 2016 at 11:51 pm
Good question, cheers.
...
February 11, 2016 at 12:12 am
Stewart "Arturius" Campbell (2/10/2016)
Nice one, thanks SteveGiven that SETUSER is deprecated, and the last two were obviously incorrect, that left only one choice...
+1
February 11, 2016 at 12:58 am
Thanks for the question.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 11, 2016 at 4:13 am
Thanks for QOTD Steve.
February 11, 2016 at 5:49 am
I use this all the time to troubleshoot permission problems others are having. I find it very useful. Thanks.
February 11, 2016 at 7:58 am
Stewart "Arturius" Campbell (2/10/2016)
Nice one, thanks SteveGiven that SETUSER is deprecated, and the last two were obviously incorrect, that left only one choice...
And here I thought SETUSER was something Steve made up; having started working principally with SQL 2005, I've always used EXECUTE AS. A quick look to BOL shows it was deprecated in 2005: https://msdn.microsoft.com/en-us/library/ms186297%28v=sql.90%29.aspx.
Actually, further search shows it was deprecated even in SQL 2000: https://technet.microsoft.com/en-us/library/aa259240%28v=sql.80%29.aspx, though there's no indication on that page of an alternative command like EXECUTE AS. I wonder if that TechNet entry for SQL 2000 was amended ex post facto. Any SQL 2000 honchos out there remember?
Rich
February 11, 2016 at 11:37 am
Rich Mechaber (2/11/2016)
Stewart "Arturius" Campbell (2/10/2016)
Nice one, thanks SteveGiven that SETUSER is deprecated, and the last two were obviously incorrect, that left only one choice...
And here I thought SETUSER was something Steve made up; having started working principally with SQL 2005, I've always used EXECUTE AS. A quick look to BOL shows it was deprecated in 2005: https://msdn.microsoft.com/en-us/library/ms186297%28v=sql.90%29.aspx.
Actually, further search shows it was deprecated even in SQL 2000: https://technet.microsoft.com/en-us/library/aa259240%28v=sql.80%29.aspx, though there's no indication on that page of an alternative command like EXECUTE AS. I wonder if that TechNet entry for SQL 2000 was amended ex post facto. Any SQL 2000 honchos out there remember?
Rich
Don't believe EXECUTE AS worked in 2000, but don't have an instance handy. It could have been added in an SP, which was common practice to add functionality back then
March 8, 2016 at 4:52 pm
Thank you for the question.
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply