Track User Changes etc

[nick.h]

Hey,

I'm recreating a database that I had in Microsoft Access, and I was looking to track the user who added records.

Originally I simply had a field that entered a public variable (that was saved with the current user name). How would I duplicate this kind of functionality in SQL Server 2008?

Ideally I want to have that data entered into a field so that they can view records that they entered, and their bosses can view the records that their team has entered.

Any ideas? Sorry if it's really basic, but I'm new to SQL Server

Nick

 

[jmcilhinney]

You can add a trigger so that a history record is added to another table each time a record is inserted, updated or deleted. You should read up on SQL Server triggers in Books Online for a start.