is it possible to find which transactions made

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

General SQL Server Forums

New to SQL Server Programming

is it possible to find which transactions made

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-02 : 08:29:43

Dear All,
in my database, for a particular time of 4 hours, some columns data became null. ofcource that is a nullable column, how can i found in that particular time which procedures or which queries executed?

the data base is in full recovery mode.

please guide me in this regard

Arnav
Even you learn 1%, Learn it with 100% confidence.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-07-02 : 08:33:43

I think you can find with default trace:

Select * from ::fn_trace_getinfo(NULL)
--find Trace file location/status/name

select * from ::fn_trace_gettable('FileName',default)
--find the results of the trace.