SQL Server lock database while stoting incoming requests in a queue

Question

Is there a way to lock an entire database from writing but at the same time storing the incoming requests in a queue or in memory until the lock is released?

edit 1: I'm looking for something similar to MySQL

'FLUSH TABLES WITH READ LOCK' and 'UNLOCK TABLES'

Thanks

I'm not exactly sure what you're looking for, but this might help: rusanu.com/2010/03/26/using-tables-as-queues — rory.ap
– rory.ap, Commented Feb 10, 2015 at 18:04
Offtopic. Not really a programming question. Try the DBA site. — Marc B
– Marc B, Commented Feb 10, 2015 at 18:05
I know it's a bad idea but this is one of my requirenments :( — MemoGarcia
– MemoGarcia, Commented Feb 10, 2015 at 18:07

Community · Accepted Answer · 2017-05-23 11:57:57Z

You can add table level lock hints with (tablock) or with (tablockx) depending if you need shared or exclusive lock -- that's of course per table.

TABLOCK vs TABLOCKX

Collectives™ on Stack Overflow

SQL Server lock database while stoting incoming requests in a queue

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related