It can be on for one and only one table at the time (not sure if it's per db or server).

One quick way to check if any table is still...

My understanding is incomplete either in the logic or in the error you are getting.  Can you add some comments in the code you just poted so I can help you out...

To my knowledge it cannot be disabled without changing the column altogether (like to an int).

What error are you getting?

Ya change my exists to yours.  The rest of the logic is all the same whether you use on exists statement or another.

This works for me.  Maybe that will put you on the right track!!

USE SSC

GO

IF EXISTS (SELECT * FROM dbo.SysObjects WHERE Name = 'UDFDemo' AND XType = 'U' AND USER_NAME(uid) =...

I'm sure you'll get a much quicker reply by trying this one out on your own that waiting for us to give it to you.

Are you getting 2 different result sets when running those as selects?

ok so you show the usernames of created and modified.  That means you need to index the pk of the users table so that the joins made on that table...

I try to keep my demos as simple as possible, but when you never understood the concept, it still can be pretty hard to understand when you first look at...

Declare tddesc as varchar(250) and you should be golden (untested).

Does this help?

USE SSC

GO

-- How do I concatenate rows into a single column?

-- Short answer is you should never do this when an outside application is presenting the data and...

That's one of those it depends questions.  If you have 99% inserts vs 1% select, then you may drop a few indexes... Especially for auditing since theorically, only programmer will...

Maybe I'm just paranoid but I feel the need to point out that 2 instances of the same report ran by the same user constitutes 2 different sesions, hence 2...

CountryID and Status Yes.

According to many gurus and Sox, auditing data should be kept completely separate from the base data, and base database.  So the 2 modified fields should be...

You can also create a foreign key between the 2 emp ids.  That way the master key can't be updated if childs exists.  You can also add the "on update casacade"...