is there any tool to lock an object in a multiuser env.?

lib

We are often many developers working on the same project, so on the same server. Is there any tool that allows a developer to lock an object in order to avoid that another one designs the same object at the same time ??

Thank you very much for your replies.

Lionel

Marije_Brummel

You can have a look at QPM by qurius, The versioning tool by Celenia or the tool that is on the download part of this website.

ara3n

Also you can create your own locking mechanism if you are working on SQL. Remember the objects are stored on Object table. So you can write sql triggers to do the locking.

Marije_Brummel

ara3n wrote:

Also you can create your own locking mechanism if you are working on SQL. Remember the objects are stored on Object table. So you can write sql triggers to do the locking.

I've heard of that before. Do you have an exapmle of that please?

lib

Thanks for the answers!! I would be grateful if ara3n can give us an example for a SQL Server trigger that does this locking mechanism...

Lionel

ultiboy

Mark Brummel wrote:

You can have a look at QPM by qurius, The versioning tool by Celenia or the tool that is on the download part of this website.

Mark, can you please give me a link for the qurius tool? Thanks

ara3n

Mark Brummel wrote:

ara3n wrote:

Also you can create your own locking mechanism if you are working on SQL. Remember the objects are stored on Object table. So you can write sql triggers to do the locking.

I've heard of that before. Do you have an exapmle of that please?

At tectura we are using it. One of my coworker who left Our Company wrote it. I've been basically reusing it. I don't know if I can post the code. It's been a while since I've looked at it. It's pretty simply. The code resides on the object trigger. I could write it from scratch and it would be my code which I worked on off hours? I could write in sql 2005 in c#?