Getting Started with Adobe After Effects - Part 6: Motion Blur
A collection of quick technology learning tips from what people around you learn every day

Sql server - Taking database to offline even when other connections open

Dec 14 2011 8:13AM by RKA   

Suppose, We need to block the access to current database and for that decided to make the db offline. For this, right click db->task-> offline. But it won't work, if some connection still open.

Fix:

ALTER DATABASE <dbname> SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO

Now SQL Server immediately take database to offline by closing an existing connection and rollbacks the transactions, which are not completed till now.

Read More..   [18 clicks]

Published under: SQL Server Tips ·  ·  ·  · 


RKA
92 · 2% · 598
15
 
5
 
11
 
0
Incorrect
 
0
Interesting
 
0
Forgotten



Submit

Your Comment


Sign Up or Login to post a comment.

"Sql server - Taking database to offline even when other connections open " rated 5 out of 5 by 15 readers
Sql server - Taking database to offline even when other connections open , 5.0 out of 5 based on 15 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]