Professional Web Applications Themes

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 -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default 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

    --
    Posted via [url]http://dbforums.com[/url]
    basidati Guest

  2. #2

    Default Re: Check for locked record

    See my reply to your post a few hours earlier.

    --

    Andrew J. Kelly
    SQL Server MVP


    "basidati" <member32603dbforums.com> wrote in message
    news:3077367.1057399224dbforums.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
    >
    > --
    > Posted via [url]http://dbforums.com[/url]

    Andrew J. Kelly 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. HELP ME : check for locked record
    By basidati in forum Microsoft SQL / MS SQL Server
    Replies: 2
    Last Post: July 5th, 03:13 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