Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  creating calendar database multiple users - locks?

Author  Topic  mbga9pgf Starting Member 1 Post Posted - 2008-12-24 : 07:37:57 My project involves creating a database which consists of (in a simplified form) a typical users table, an events table and a Location table. The basis of the database is to create an accessible calendar that is editable and viewable by multiple users. For example, multiple users can interact (view) data concurrently, as well as edit data in the table, including creating new events, adding and deleting members from events and changing locations. I dont want to use exchange server as it is too limiting for other aspects of the project. How the heck can I create such a database without the hideous collisions that are going to occur? I obviously will require a connected architecture, but dont know how to ensure the data displayed to users is the up to date version? I am fairly new to sql, understand the theory behind table locking etc but implementing is a different matter! Any pointers of where I should start? How can I get the DB to trigger changes in my data adapter if another connected user changes the database? How Can I get my front end to display an up to date calendar without the user clicking an update button and at the same time caning db with repeat multiple queries? My front-end is a c# .net windows form as well as .net webforms. Newbie coming through! !