Does Idera's compliance manager allow you to log someone who just connected to a database or just selected data without changing anything?

Just a couple of questions:

How do I find my own posts? (Hope I can find this one later if someone answers this question)

Did the vendor forums go away?

I have been looking into this myself.

I was reading the info on Lumigent Audit DB. The marketing info claims it does job, but I was trying to find if...

Well, with praise like that, I'm glad I asked.  Thanks. 

You are mistaken about the OP requirements.  He said his table had 1 million rows and that the lookup tables had around 100 rows.  If he is scanning that table,...

Try it this way:

Query1: 
begin transaction
insert into dbo.testtable values(5,'trante', 'testfor tran')
if @@error = 0 commit else rollback

Jeff, I'm a little unsure what you're trying to say there. 

That is always a sore point with me, especially when someone wants me to FTP them a 100 GB database.

If they want test data, I tell them to buy a large USB...

I don’t see how your last post is relevant to this discussion.  The testing you did completely fails to address the points you raised in your prior post about the...

Matt: Technically, the functions in my post are non-deterministic from the SQL Server point of view, but only because they were not created with the "with schemabinding" option.  However, as...

It is probably not a good idea to do this with functions for a table with that many rows.  You should read the topic below.

Demo Performance Penalty of User Defined...

I think this does what you want, and you don’t have to worry about the setting of DATEFIRST.

This has links to various date function:

Date/Time Info and Script...

The script on the link below may be useful for what you are trying to do.

Get Server Database File Information

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=89058

RTRIM does work.  You are just mistaken in assuming that SQL Server will adjust the column width to match the maximum size of the trimmed column.  SQL Server just makes the output column the size...

Did you backup to 4 local drives because you didn't have enough space for a full backup on a single drive?

Or were you doing it mainly for backup speed?