By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,659 Members | 1,678 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,659 IT Pros & Developers. It's quick & easy.

Implementing read-write locks

P: n/a
Hi,
I would like to use database locking mechanism to control access to an
external resource (like file system).
What I need is
1. an exclusive (write) lock conflicting with any access to the
resource (both for read and write)
2. non-exlusive (read) lock conflicting with writes only
How this could be done?
I'd appreciate any reply.
Vadim

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

<va*****@gmail.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...
Hi,
I would like to use database locking mechanism to control access to an
external resource (like file system).
What I need is
1. an exclusive (write) lock conflicting with any access to the
resource (both for read and write)
2. non-exlusive (read) lock conflicting with writes only
How this could be done?
I'd appreciate any reply.
Vadim


Application locks could be one solution - check out sp_getapplock in Books
Online.

Simon
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.