Personally I'd track any DML that's not within an SP. Starting with TSQL:SQL:StmtStarting and then filtering out obvious garbage (SET statements etc). That may come close, but then...

Often my first action in such circumstances is to run profiler interactively (locally if possible) to capture SQL with a CPU > zero. I tend to run it for...

Were they valid login names on your server? ie. I seen servers open to the Internet that regularly experience similar hack attempts on login ids such as SA, SQL,...

Change to the schema affect the system tables which, unfortunately, cannot have triggers on them.

You can schedule a 24-hour trace on the server, looking for statements starting with CREATE, DROP...

Can you post the actual RAISERROR statement?

If you used the SQL Server Agent thingy in BackupExec then you may not be given the option of doing as Shas3 suggests. If that's the case, and if...

Those busy objects are MYSQL components (data, log and error files).

Looks like you're trying to back up MYSQL database files whilst the Mysql service is still running.

There could be so many locks taken that locks are escalated to page or even table locks. You may want to run Profiler and look at lock acquisition and...

Is "Compilations/Sec" different to "re-Compilations/Sec"? The latter may refer to SPs whilst the former to any ad hoc SQL batches?

Hmmm. Quite complicated, especially with VAR*, N*, text and nullable columns. Also the setting of text-in-row for the table would probably have an effect.

Suggest having a...

You've hit the SQL 6.5 hard limit of 64k bytes in a stored procedure. (this limit became about 250mb with the introduction of SQL 7.0). This is 255...

I don't have your schema, so here's a NORTHWIND example of using sp_executesql with:

- a dynamically constructed SQL string (equivalent to tacking @psyntax on the end)

- an input parameter...

It MIGHT be an ambiguity arising from your outer join syntax. Possibly worth trying a LEFT OUTER JOIN instead of "*=". From BOL:

Cheers,
- Mark