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?

SELECT * FROM sysobjects WHERE xtype='P' OR xtype = 'S' OR xtype = 'U'

  |--Compute Scalar(<Removed for brevity> )

       |--Clustered Index Scan(OBJECT: ([master].[dbo].[sysobjects].[sysobjects]), WHERE: (([sysobjects].[xtype]='P' OR [sysobjects].[xtype]='S') OR [sysobjects].[xtype]='U'))

No difference. the query plans for the two are identical. In fact, checking the query plan, the query parser expanded the second out into ORs.

I tried these two

SELECT

That's brilliant. Thanks. I didn't think of looking there.

Can you read those from T-SQL? CLR?

Company I work for doesn't provide laptops. We all work on desktop machines.

I bought my own laptop, and while I do sometimes do work on it, it is my machine...