Forum Replies Created

Viewing 15 posts - 46 through 60 (of 66 total)

  • RE: record locking in n-tier applications

    Hi i am trying to do do he same thing but please some give me example that if i query on table then how can i lock the table or...

  • RE: return username or id?

    would you please give me an example that how can i do it! i have pasted the stored porcedure that i want to use as you have suggested in the...

  • RE: return username or id?

    Hi phil,

    I did explain that situation to them but they are not ready to accept that fact the if i allowed shared lock on the stored procedure or queries the...

  • RE: return username or id?

    oh ok i understand. but is it possible that i can check that the record id 45 is being accessed and then return 1 or 0 on...

  • RE: error message prompt!

    Hi phil that clears some clouds of confusion but the question if i add field which tells me that the record is locked or not but how am i going...

  • RE: error message prompt!

    Hi phil,

    I don't have the separat field that indicates the record is locked or not!! but trying to do this because they want to see the error message on front...

  • RE: error message prompt!

    Sorry phil i do understand that but just would like to do this

    IsThisRecordLocked

    (

                @RecordID int

  • RE: PK violation in replication

    one solution is there that delete the replication and dts all the data from one server to another server and then recreate the replication. it might help!

    Take Care.

  • RE: PK violation in replication

    what kind of replication you are trying to use! Trasaction, merge or snapshot! in transaction if that error comes then you have to go manually to change that data or...

  • RE: locking this query?

    Hi All,

    Thank you for replying, Actually i am trying to achieve is this. if one user log in to access this sp or other sp's which modifies the data at...

  • RE: what is S-Lock?

    Would you please give me an example that how can i set the lock on all the sp or queries?

    Please

     

    Thanks

  • RE: what is S-Lock?

    But how can i implement on the DB!

    Thanks

  • RE: locking users!

    is there a way that i can set up lock on database by itself that does it for any time user logs in and select data but can't make changes...

  • RE: recovery from different server.

    hi i have set the permission for everyone for full access. but still getting error!

    Thanks

  • RE: recovery from different server.

    hi there i tried that but it could not open the back up device but it is shared on network! what could it be wrong?

     

    thanks.

Viewing 15 posts - 46 through 60 (of 66 total)