MS SQL Server - debug via Enterprise Manager

Author

debug via Enterprise Manager

Dariusz Tomon

2006-02-04, 1:23 pm

Hi

I wonder if there is a trick I can use to debug what was changed in my
database (mssql2000).
The idea maybe sound stupid but my boss have got old console application
which is doing some changes in database (only in data in tables rather:). I
have no code for that application and we are wondering where this appl.
writes - what changes and so on.

Any idea?

Darek

John Bell

2006-02-04, 1:23 pm

Hi

You may want to use SQL Profiler to see what statements the application is
sending to the database server.

John

"Dariusz Tomon" <d.tomon@mazars.pl> wrote in message
news:eIJBW$aKGHA.216@TK2MSFTNGP15.phx.gbl...
> Hi
>
> I wonder if there is a trick I can use to debug what was changed in my
> database (mssql2000).
> The idea maybe sound stupid but my boss have got old console application
> which is doing some changes in database (only in data in tables rather:).
> I have no code for that application and we are wondering where this appl.
> writes - what changes and so on.
>
> Any idea?
>
> Darek
>

Sponsored Links