Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question

migrated from stackoverflow.com Mar 29 '13 at 13:52

This question came from our site for professional and enthusiast programmers.

7  
This is a terrible idea for a lot of reasons. "I don't have time" is not a great reason to give everyone the keys to the store. –  JNK Mar 29 '13 at 12:41
5  
You are in for a world of trouble giving everyone access to the data. Oops I truncated a table –  bluefeet Mar 29 '13 at 12:42
3  
@TropicThunder, wrong! I've been writing software for more than a decade, 13 years to be exact, and three years ago while trying to get something done for a customer I got interrupted and didn't highlight the WHERE clause I wrote in Management Studio. A college degree means NOTHING! Life happens my friend, and if you do this, you will pay. –  Michael Perrenoud Mar 29 '13 at 12:55
1  
@bluefeet, I worked with a man that had a college degree and he worked as the DBA. I asked him to use the data centers restore application to get me yesterdays backup of a database and place it on a new database so I can fix something that somebody messed up in the database (oh and they had a college degree too) and he overwrote the LIVE database! –  Michael Perrenoud Mar 29 '13 at 13:00
6  
This is one of the worst idea I've heard in a long, long time. Precisely equivalent to "You don't care about your data". –  Vincent Malgrat Mar 29 '13 at 13:50

2 Answers 2

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.

share|improve this answer
1  
+1 Exactly what LightSwitch is intended for. –  Mark Storey-Smith Mar 29 '13 at 13:02
    
Better solution than mine! –  Jason Carter Mar 29 '13 at 13:03

While I don't agree with your motives 'I don't have time' I do understand the need.

Ensure you have appropriate security setup for that portion, and for your data changes you want to Checkout Change Data Capture if you are on SQL2008R2 which of course is available in 2012 as well, below that you will have to roll your own solution using triggers, but i doubt you'll have time for that.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.