Exclusive Table Checkouts / Table Locking

[craigsdc]

Hi,

We currently using the Shared Database Development model, and have a quick question regarding sql source control on development machines.

Is it possible to do exclusive checkout of tables at all?

Meaning, if user X makes a change to a table, it auto checks out the table and user Y cannot make changes to that table until user X checks in the changes.

Currently we have SQL Source control on the server only, and not on our development machines.. If it is installed on our development machines will SSMS detect that use X has made changes, and not allow user Y to modify it at all.

Thanks,
Craig

[james.billings]

Currently, SQL Source Control doesn't perform the locking checkouts you refer to - please check this suggestion on our uservoice: http://redgate.uservoice.com/forums/39019-sql-source-control/suggestions/802123-tfs-exclusive-checkout-svn-lock?ref=title where you can add your own comments and votes.