If you aren't going to use the trigger anymore, drop it. If you do plan on using it in the future, I would disable it. Another alternative is to...

dbcc_inputbuffer(SPID)

I would recommend Idera.

You could do something like that in SSIS.

What if you enabled auditing by machine? Then you could capture the machine and correlate it back.

Mirroring.

RTRIM and LTRIM are your friends in this case.

Ever thought of doing transactional replication instead? I've setup 2000 to 2008 with no problems.

A lot more detail is going to be required to get a good answer.

Jeff Moden (3/10/2010)

That works fine but it's a bit of a PITA to maintain compared to a SAN clone. Also, the purpose of a...

Why not implement transactional replication?

I was just about to post the same. Good to know there are people testing these solutions/examples.

Jeff- That is very good advice, I did not know that.

Did you bounce the server? I've run into the same thing and a reboot fixed it. I assume if you are running express that it's not a critical box and...

I want a refund on my point.

You can get the SPID from activity monitor too.