I'm not getting that error for those snippets. Are there any other statements in the batch?

Okay, the main issues with triggers, in my opinion are:

1. Trigger code is "hidden". Unless you are the designer/developer you may forget to look for triggers.

2. Triggers...

Normally I'd recommend batching, but it depends on amount of data and other activity on the database(s). 20-30k rows are really not that many.

I recommend reading this article[/url] about triggers.

I believe, and it has been awhile, that printing directly from the report (wasn't supported in the original 2000 release at all) requires a printing control to be installed/added to...

How did you grant rights to the reports, via specific user or by AD group? If by group the best you can get without going out to AD is...

From BOL about Global Temp Tables:

Global temporary tables are visible to any user and any connection after they are created, and are deleted when all users that are referencing the...

I think I understand what the trigger is supposed to do (not an ORACLE guy) so I think this is how I would do it in SQL Server. Definitely...

Okay, I'm looking at it, but while I'm looking at it I suggest you read this article[/url] as triggers perform differently in SQL Server than in Oracle.

Apparently you aren't the only one looking for this information. Here is a connect item about it being missing from documentation. I'd encourage you to vote on it...

Can you post what the solution was? It's great that it's solved, but I know I'd like to be able to help someone else if they have the same...

Wow, SQL Server not responding many times. Sounds like some major application issues. I'd start by setting up a PerfMon log, starting with the counters mentioned in...

What OS?

Do you have any third-party SQL Server tools installed like RedGate SQLToolbelt or addins to SSMS? These are just some guesses.

Thanks for posting the link Dan. May come in handy.

I typically copy...