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: http://rusanu.com/2010/03/26/using-tables-as-queues/ — rory.ap, Feb 10 '15 at 18:04
Offtopic. Not really a programming question. Try the DBA site. — Marc B, Feb 10 '15 at 18:05
I know it's a bad idea but this is one of my requirenments :( — MemoGarcia, Feb 10 '15 at 18:07

score 1 · Answer 1 · edited May 23 '17 at 11:57

1

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

edited May 23 '17 at 11:57

Community

1
1

answered Feb 10 '15 at 18:15

James Z

12,209
10
24
44

SQL Server lock database while stoting incoming requests in a queue

1 Answers1