Just one note. Multi-statement table valued functions do not and will not perform well with larger row sets if you are joining those functions together or joining them to other...

That's not what I asked for.

Go into the maintenance plan designer and set that maintenance plan to log all output to a file. Run the plan again and then get...

So native backups? You're not using litespeed or any other 3rd party tool?

If that error's raised by the native backups, then you're probably going to have to call customer support....

SQL Server Profiler. It's a tool that can trace events occurring on a SQL Server.

Maybe. Try attaching the database using the CREATE DATABASE ... FOR ATTACH statement.

Why no backups?

Dunno. Depends on how the query's done in php.

If you run a profiler trace against the server, what are the command you see been run against the SQL server when...

Are you using native backups or 3rd party backup tool?

You should be able to detect it using a query of sys.databases. I'm not sure how to create an alert based of that though

Plan guides don't need changes to the source query. Basically, it's an object in SQL that tells the optimiser 'when you see a query of this form, apply these hints'

It's...

Why? What is that going to achieve?

Those commands will also drop all of the data pages from cache, forcing SQL to go to disk next time it needs data.

Do not run those on a busy production...

Traceflag 1222 is preferred over 1204 on SQL 2005 as it provides a lot more info. 3605 is not required for logging deadlock info to the error log.

To get deadlock...

Not possible.

The only database-scoped triggers are the DDL triggers that fire on schema changes. DML triggers have to be placed on each table and will fire when that table is...

ntext has a limit of 2GB. If the string is getting trimmed at 4000 characters, then it has something to do with how you're putting the data in or how...

Can you post one of the CREATE LOGIN statements that the script generated?