There is no SET SHOWPLAN statement in MS SQL 7.0. There are
SET SHOWPLAN_TEXT and SET SHOWPLAN_ALL, but this statements
turns on SET NOEXEC ON, and you can see the showplan only
separately with the query execution.

There is no system table syslogs in MS SQL 7.0.
So this SQL statement:

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

Direct update

You must not change the fields from the clustered index for Direct update.
It is the most effective method of modification. When it is used the data
changed on its physical place and only three rows will be written into the
transactional log.