Check for locked record

Ask a Question related to Microsoft SQL / MS SQL Server, Design and Development.

  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. Similar Questions and Discussions

    1. Check the record in Database using ASP.NET
      Dear All, Dreamweaver user who want to develop a site using ASP.NET have got critical time. In Server behavious we doesn't have User...
    2. Check record before Inserting
      Hi, I have troble in inserting new records into database, I have a unique date field it should not repeate again, i.e. one record per single day,...
    3. Check new username on Update record??
      Hi - using ASP/Access/Vbscript. How can I use the "check new username" behaviour in DW on UPDATE RECORD? DW tells me that it needs an insert...
    4. Check if record set rturn something
      Try: If rstPart.Fields.Item("partID").Value < 0 Then ... Is it a numeric value in the column? Is it possible that it's null? If...
    5. 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...
  3. #2

    Default Re: Check for locked record

    See my reply to your post a few hours earlier.

    --

    Andrew J. Kelly
    SQL Server MVP


    "basidati" <member32603@dbforums.com> wrote in message
    news:3077367.1057399224@dbforums.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

Posting Permissions

  • You may not post new threads
  • You may 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