On this site, yes, frequently.

We reference Books Online and MSDN instead. 😀

If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but...

Happy normal working day to all the people in the rest of the world.

Any errors in the SQL error log?

Is this the first time that you've seen an IO error?

When you have a couple hours where the server won't be heavily used, please...

Not much point in contacting CSS. SQL 2000 is no longer supported. (unless your company has an extended support contract with MS that is)

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?