CODEWITHSUNDEEP
t-sqlsql-server-2008-r2monitoring
Nam G VU
Nam G VU

Reputation: 35384

Is it possible to write t-sql script to show all changes made to the database rows recently?

I'm learning a new product of my company and the database is huge.

What I'm doing is to learn feature by feature and through that to understand the codes and the associated database's data/functions/ect.

What I need: To see the change-set made to the database/data-rows recently, e.g. after I create a new user account, I want to see what are the new rows updated/created after I do that.

Is it possible? Please share if it is. Thank you!

Nam.

Upvotes: 1

Views: 241

Answers (1)

Mikael Eriksson
Mikael Eriksson

Reputation: 138960

I would set up a trace with the SQL Server Profiler. In the trace you can see what the client does when you create a new user.

Upvotes: 2

Related Questions