Wednesday, March 7, 2012

How can I have a log of all SQL Server transactions ?

Hi guys !
Any body knows that how can i have a log of all SQL Server transactions ?
Thank's
SQL Server is writing every transaction in its own transaction log. There
are couple of 3rd party log readers around. Also, you can use Profiler, a
tool that ships with SQL Server, to catch all T-SQL commands.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions ?
> Thank's
|||Hi
You do have a LOG . Lookup Transaction Log file in the BOL for more details
"SQLBIz" <SQLBIz@.discussions.microsoft.com> wrote in message
news:CF84C3CE-FD2F-4746-BB53-B7F275C60E18@.microsoft.com...
> Hi guys !
> Any body knows that how can i have a log of all SQL Server transactions ?
> Thank's

No comments:

Post a Comment