Kill Database sessions

Question

Post reply

Kill Database sessions

mobasha

SSCertifiable

Points: 5334
More actions
August 28, 2008 at 11:31 am

#197087

Comments posted to this topic are about the item Kill Database sessions
..>>..
MobashA

Viewing 3 posts - 1 through 2 (of 2 total)

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

akljfhnlaflkj SSC Guru Points: 76202 More actions · Answer 1

akljfhnlaflkj

SSC Guru

Points: 76202

January 9, 2017 at 7:52 am

#1921382

Good, because we occasionally have a need for this.

Jeff Moden SSC Guru Points: 1004290 More actions · Answer 2

It's much easier to just set the database to the single user mode with an immediate rollback.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)