meerabhuva wrote: WriteCategory - int - metadata value ( Binary number for eg. 2) That's one way, but it will limit you to thirty-two categories. Better to have a Category table and allow many-to-many relationships with Books and Authors. Category ID Description 1 Mystery 2 Romance 3 Sci-Fi Author ID Name 1 Douglas Adams AuthorCategory AuthorID CategoryID 1 3 <-- Douglas Adams + Sci-Fi Book ID Title 1 The HitchHikers... BookCategory BookID CategoryID 1 3 <-- The HitchHikers... + Sci-Fi

You may want to consider using your own locking logic with the help of "sp_getapplock". http://msdn.microsoft.com/en-us/library/ms189823.aspx[^] Be very careful when implementing a locking strategy you may bring your entire application to a screeching halt if locks are not released in a timely manner. You may want to use the sp_getapplock as a method to warn users that a particular account is being updated and not place any hard locks. You could also use this to indicate who has the "lock". Good luck.

The link below may get you started: Implementing Client Callbacks Without Postbacks in ASP.NET Web Pages[^]