I'm guessing too many plans.

Is there a trigger on the table?

Maybe it's just a phrasing issue, but an update statement is not going to insert anything into the database. It's going to modify an...

Run profiler and capture the SP_Completed event. That will get you the stats for every proc run.

You could run the proc with the execution plan on and see which queries...

It's created by the optimiser when running queries so that it can get info about the distribution of data in the column, to get a better execution plan.

See this post...

No idea. The message you posted doesn't...

SQL 2005 caches the structure of frequently used temp tables. It's an optimisation to reduce the impact of frequently creating and dropping the same table. That may be what you're...

There's no way to move a database while it's online.

The two ways to move a DB are the detach/attach method you have, or to do an ALTER DATABASE ......

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

Post the exact error message, and read this blog post. http://www.sqlskills.com/BLOGS/PAUL/post/TechEd-Demo-Creating-detaching-re-attaching-and-fixing-a-suspect-database.aspx

For what it's worth, you should never detach a suspect or corrupt database, because it will not reattach.

Do you have...

Why are you truncating the transaction log? If you don't want to backup the log and point-in-time recovery is not required, put the DB into simple recovery and leave it...

Michael Baas (1/7/2009)

---

Ok, case closed - many thanks for asking. I really forgot these triggers, but they guys only support updating one record at a time, so that explains...

There should be an entry in the SQL error log saying why the database has been marked suspect. Can you look through the error log and see if there's anything...

matsinopoulos (1/7/2009)

---

[

However, I realized that it does not contain the line breaks. The whole value of definition is one line string. How should I recover the body of the...

Thought so.

Those aren't indexes. They're automatically created system statistics and they can be safely dropped if they're causing problems (as they are here). The optimiser will recreate any that it...

How many indexes do you have?

Are you sure there are no redundant indexes?

Are they all been used?

Please post SQL 2000-related questions in the SQL 2000 forums in the future. If...