log all queries

[Marco Dieckhoff]

Hi!

In order to debug a program written for us I'd like to log all
queries to a database/a specific table in MS SQL Server 2000.

Are there any options to get a logging like this and how do I
enable it?

--
Marco Dieckhoff
icq# 22243433
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys

[Anith Sen]

Not exactly. One clumsy option, is to turn on the profiler to track the
SELECT statements & dumb them into an ASCII file. On large databases with
heavy transactions, this may not be worth it though.

--
- Anith
( Please reply to newsgroups only )

[Simon Hayes]

"Marco Dieckhoff" <di***@gmx.de> wrote in message
news:bj**********@rzcomm2.rz.tu-bs.de...

Hi!

In order to debug a program written for us I'd like to log all
queries to a database/a specific table in MS SQL Server 2000.

Are there any options to get a logging like this and how do I
enable it?

--
Marco Dieckhoff
icq# 22243433
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys

You can use Profiler, and set a filter for the tables/databases that you're
interested in. You can either run the trace from the Profiler GUI, or by
creating a server-side trace with the sp_trace% procs. There is plenty of
information on this in Books Online.

Simon

[Tom Kitta]

Hello,

How about writing a trigger attached to the table in question for
select/update/delete operations that will record data to some audit table?

TK
"Marco Dieckhoff" <di***@gmx.de> wrote in message
news:bj**********@rzcomm2.rz.tu-bs.de...

Hi!

In order to debug a program written for us I'd like to log all
queries to a database/a specific table in MS SQL Server 2000.

Are there any options to get a logging like this and how do I
enable it?

--
Marco Dieckhoff
icq# 22243433
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys

[John Bell]

Select triggers are not in SQL 2000!!

If you access your tables by stored procedure then you can implement an
auditing function.

John

"Tom Kitta" <to*@energyshop.com> wrote in message
news:B7*******************@news02.bloor.is.net.cab le.rogers.com...

Hello,

How about writing a trigger attached to the table in question for
select/update/delete operations that will record data to some audit table?

TK
"Marco Dieckhoff" <di***@gmx.de> wrote in message
news:bj**********@rzcomm2.rz.tu-bs.de...

Hi!

In order to debug a program written for us I'd like to log all
queries to a database/a specific table in MS SQL Server 2000.

Are there any options to get a logging like this and how do I
enable it?

--
Marco Dieckhoff
icq# 22243433
GPG Key 0x1A6C95BA -- http://www.frankonia-brunonia.de/keys