Are you sure you are connected to the right server / DB?

It has to work if you put the name that sysobjects gives you in brackets... that's absolutly a can't fail proposition... unless you have a corrupt installation or maybe DB...

I'd like to see the rest of the trigger, there's probablye a way to only do 1 update instead of four. Your query should look like this :

update...

Not a required feature. The fact that you need to alter the procedure suggests that you will manually (99% of the time) will change the code.

That feature has been...

Have you tried this syntax? :::

SELEC Whatever FROM dbo.[db.documents]

if that fails you can always run this to see the actual table name

Select * from sys.sysobjects where name like %documents% and...

Repeating the warning.... don't create triggers on the fly.

If you have a DBA job of creating audit triggers and want to write your own code here's how to bypass that...

That really makes...

This screams poor table design... why don't you have one row per date?

If this is the case of a report you need to run, or something of the likes, or...

Sherbrooke, Québec, Canada (90 minute south of Montréal).

It was more a contract than a job... but I'm sure I can find more of those if I need to... but I...

Sorry for my over estimations... but the last "jobs" I had, I was charging 75$ / hour, that's easily in the 6 figures. I just assume that it was...

I just found a site called payscale.com From what I can tell the average seems to be around 45-55K / year.

You might want to fill out the survey...

Montréal is in Québec, Canada.

It's one of the biggest towns in Canada.

I have no idea of the average salary there... should be at least 6 figures (my own personal guess...

You can find a trigger generator that will make all the code necessary for the triggers.

Or you can build one. It may take a few hours of work, but...

My client has a small in-house system with only 8 users on it, no website. The difference between both trigger system's performance is enough to keep him from buying another...

Fine, turn the trigger back on, then PRINT the query instead of executing it.

Analyse that query and you'll find your problem there.

Also you are asking for troubles by auditing this...