SQL Server Change Tracking I work for a company of about 80 employees and they all seem to need access to our database on a regular basis. I don't have time to write applications to meet all of their needs so I'm just going to install SQL Server Management Studio on each employee's computer so they can help themselves to the data. Does anyone know if there's a way to write a wrapper for SQL Server that would save all database transactions to a text file so I can monitor what changes everyone is making?
I may get dinged for this, I may not, but if you don't have time I've got a fantastic solution for you. Download Visual Studio LightSwith - you can build a database application in less than five minutes and have it deployed in less than ten - I've done it.

Make time, find the right tools, but do not give them the keys to the database.

In fact, LightSwitch is so dead simple, you could teach some other folks there how to use it at some level.