Look for exclusive lock in these documents. It may give you some ideas:
http://www.sql-server-performance.com/rd_table_hints.asphttp://www.databasejournal.com/features/mssql/article.php/3289661>Hi William, what I'm trying to do is get exclusive access to a SQL table , in Foxpro I used to use Fopen() to try to open a dbf and if it failed I knew someone had the table open, I don't think I can achieve this in SQL server, thanks very much for your efforts and if I find a way I will post back
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"