Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Semaphores?

Author  Topic 

queenofcode
Starting Member

6 Posts

Posted - 2010-01-13 : 15:17:26
I thought I was fairly well versed in SQL, until someone asked me to lock a table using a semaphore, update the table, then unlock it. As odd as it sounds, I wasn't able to find any helpful information from Googling.

How do I lock a table using a semaphore? I've read examples of what a semaphore is (the chopstick problem, etc.) but using it is a whole different matter.

Any help would be GREATLY appreciated!

<geek> The Self-Proclaimed Queen of Code :) </geek>

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-01-13 : 16:07:35
see this: http://www.sqlservercentral.com/articles/Miscellaneous/2649/
Go to Top of Page
   

- Advertisement -