Professional Web Applications Themes

HELP ME : check for locked record - Microsoft SQL / MS SQL Server

How can i check if the record i want to select is already locked by another user? There is a way to know the resource id associated with the record in a table and compare that with those shown by the sp_lock? thanks -- Direct access to this group with [url]http://web2news.com[/url] [url]http://web2news.com/?microsoft.public.sqlserver.programming[/url]...

  1. #1

    Default HELP ME : check for locked record

    How can i check if the record i want to select is already locked by
    another user? There is a way to know the resource id associated with the
    record in a table and compare that with those shown by the sp_lock?

    thanks
    --
    Direct access to this group with [url]http://web2news.com[/url]
    [url]http://web2news.com/?microsoft.public.sqlserver.programming[/url]
    basidati Guest

  2. #2

    Default Re: HELP ME : check for locked record

    There is no really clean way to do this but if you check out hte
    "LOCK_TIMEOUT setting" in BooksOnLine it gives a pretty good description of
    a way that may be of use.

    --

    Andrew J. Kelly
    SQL Server MVP


    "basidati" <basidati.news.invalidweb2news.net> wrote in message
    news:48191N976web2news.com...
    > How can i check if the record i want to select is already locked by
    > another user? There is a way to know the resource id associated with the
    > record in a table and compare that with those shown by the sp_lock?
    >
    > thanks
    > --
    > Direct access to this group with [url]http://web2news.com[/url]
    > [url]http://web2news.com/?microsoft.public.sqlserver.programming[/url]

    Andrew J. Kelly Guest

  3. #3

    Default Re: HELP ME : check for locked record

    This is my problem:
    I have 2 table Orders and Items . When a user select an order (to make
    an invoice for example) i want other user can't select that order for
    the same operation, but they can select orders and their details for
    read only operation (to see the order list for example).

    I hope my english is clear.


    --
    Direct access to this group with [url]http://web2news.com[/url]
    [url]http://web2news.com/?microsoft.public.sqlserver.programming[/url]
    basidati Guest

Similar Threads

  1. Check the record in Database using ASP.NET
    By arusmart in forum Dreamweaver AppDev
    Replies: 1
    Last Post: May 27th, 10:39 AM
  2. Check record before Inserting
    By arusmart in forum Dreamweaver AppDev
    Replies: 3
    Last Post: May 26th, 09:18 PM
  3. Check new username on Update record??
    By btn in forum Dreamweaver AppDev
    Replies: 1
    Last Post: April 23rd, 07:30 AM
  4. Check if record set rturn something
    By Ray at in forum ASP Database
    Replies: 4
    Last Post: October 30th, 05:44 PM
  5. Check for locked record
    By basidati in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 5th, 02:49 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139