When you set up a trace was it with the default options? If so, 40000 isn't that much in 10 min. On some of my servers I can generate a...

Sorry, I'm on course at the moment so replies are going to be occational.

What did you trace? What I think would help, since you're getting this often, is have a...

Database backup at 13:36

Database backup, or log backup? I guess the latter, since db backups don't truncate the log.

I think what might be necessary at this point is to...

Row_Number is a new feature in 2005. there's no function in 2000 that does that.

You can try top. Something like

SELECT TOP 10

phone_no,model,cur_version,

You can get the details of the new rows from the inserted table. It will contain all the rows that were inserted by the statement that fired the trigger.

Accept their offer, and check that the log is been backed up. Check how often, and make sure it's not failing.

DBCC

SQLPerf(LogSpace)

It'll show you the percentage of...

Possibly, but there's a lot of info in there and it's not intended to be human-readable. It's confusing at best.

Run DBCC OPENTRAN to see if there are any open transactions....

View what about it? The size, the percentage full, the actual log records?

While it is possible to read the log records, I really don't recomend it. It's verbose, completely undocumented...

Is this a homework assignment, or a test or some sort? It certainly looks like it.

What specifically are you having problems with?

Probably your path is wrong. At the command prompt type path and see what it returns.

I can't remember offhand where to add paths, but it souldn't be hard to...

First thing to do is to check that the transaction log is actually getting backed up. It won't be the first time that a log should be getting backed up,...

Can you give us the structure of the audit table and some sample data?

Have multiple rows been changed? How are those records identified in the audit table?

Triggers is certainly an option, and probably is the one with the least work required.

Just remember with triggers that a trigger fires once for an change and has all...

Can you perhaps post some sample data and desired output?

Maybe there's another way of doing this.

That's definatly odd SQL.

What is it that you're trying to do?