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"...

This works in 2000, shouldn't be hard to tweak for 2k5.

SELECT Name, OBJECTPROPERTY(id, 'IsDeterministic') AS isDeterministic FROM dbo.SysObjects WHERE XType = 'FN' ORDER BY OBJECTPROPERTY(id, 'IsDeterministic') DESC, Name

How about you search how to make a trigger work on a set of rows.  I'm sure that this come in handy someday!!

I think that she needs help on the fact that building a single index on a very large table takes a lot of time VS a course on why to...