Windows Forum

Ask something
Discussion Locked

sql 7.0

0 helpful
5 replies

by mzee

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

iam currently running a sql7.0 database and i use windows nt security. My question is:
How can i log all the changes to my database, so if there is a mistake, then i can go to the log and see who made that mistake, what date and what time ?

5 replies

by dmiles

You can view the server logs in version 6.5 and below,viewing log files in version 7.0 is not that easy.
Ref:Inside SQL Server:SQL Server 7.0 Transaction Log-http://redirect.inktomi.com/click?u=http://sqlmag.win2000mag-asap.com/info/com

by maxwell edison

You may use the following undocumented command to view the log:

DBCC log (dbid, [, type={0|1|2|3|4}])

where dbid - is the database id, you can find this id in the sysdatabases
system table in the master database.

type - is the type of the output:

0 - minimum information (operation, context, transaction id)

1 - more information (plus flags, tags, row length)

2 - very detailed information (plus object name, index name,
page id, slot id) 3 - full information about each operation

4 - full information about each operation plus hexadecimal dump
of the current transactional log's row.

by default type = 0

Good luck and have a GREAT 2002!

Maxwell

This discussion is closed to new replies.