Backing up from SETUSER

Question

Post reply

Backing up from SETUSER

Steve Jones - SSC Editor

SSC Guru

Points: 736212
More actions
March 5, 2015 at 5:00 am

#75713

Comments posted to this topic are about the item Backing up from SETUSER
March 6, 2015 at 2:42 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

lcajui Old Hand Points: 365 More actions · Answer 1

Nice question, but the date of the question is 19/03/2015 :crazy:

Sean Lange SSC Guru Points: 286590 More actions · Answer 2

DBCC TIMEWARP is active again I see. We have a question from the future about a deprecated feature. :w00t:

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 3

lcajui (3/5/2015)
Nice question, but the date of the question is 19/03/2015 :crazy:

+1

RK Mandava SSCarpal Tunnel Points: 4153 More actions · Answer 4

Sean Lange (3/5/2015)
DBCC TIMEWARP is active again I see. We have a question from the future about a deprecated feature. :w00t:

+1

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

Sean Lange (3/5/2015)
DBCC TIMEWARP is active again I see. We have a question from the future about a deprecated feature. :w00t:

Yeehaw

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 6

I typically prefer to use EXECUTE AS and REVERT. It is a good question Doc Brown.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Revenant SSC-Forever Points: 42467 More actions · Answer 7

This marks the first time I have answered a question that has not been asked yet. 😀

Thanks, Steve!

Sean Pearce SSCoach Points: 15999 More actions · Answer 8

Sean Lange (3/5/2015)
DBCC TIMEWARP is active again I see. We have a question from the future about a deprecated feature. :w00t:

I'm sure I just saw a DeLorean.

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

Stuart Davies SSCoach Points: 19505 More actions · Answer 9

Revenant (3/5/2015)
This marks the first time I have answered a question that has not been asked yet. 😀
Thanks, Steve!

But that's only because SSC is sooo good 😎

-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

Great question, thanks.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Ed Wagner SSC Guru Points: 287026 More actions · Answer 11

SQLRNNR (3/5/2015)
I typically prefer to use EXECUTE AS and REVERT. It is a good question Doc Brown.

I use the same. Good trick with the date, though. At least we now know who has the DBCC TIMEWARP parameter manual. 😛

Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions

Hany Helmy SSChampion Points: 13921 More actions · Answer 12

Never used it before SETUSER, but very good question despite of the date issue.

Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant

Toreador SSChampion Points: 11365 More actions · Answer 13

Hany Helmy (3/8/2015)
Never used it before SETUSER, but very good question despite of the date issue.

I'm not sure that it is a terribly useful question. What benefit is there in bringing a deprecated function to the attention of people who've not come across it?