The checkbox is already checked.  In addition, I already had the thought of a delay.  The entire package right now takes around 13 seconds.  I added a SQL Task causing...

I can't tell you why (MS would have to do that), but before you can even run the checkdb with "repair option", the database must be in single user mode....

One of our thoughts right now is to create a second instance on our primary development server just for profiling. We refresh our development databases from our production systems...

quote:

---

Nope. Is this in general, or following a big delete/truncate? Do you update stats manually or set the db option? What SQL...

quote:

---

One of the rules of thumb we follow where I work is if there are minor issues, we want a DBA looking...

quote:

---

Refer to KB Q290602

This says there is a known bug when system databases are included in the maintenance plan (and explains why).

My...

quote:

---

Sorry I don't reminder the details, but it seems I remember reading that under SQL 2K the repair option required single user...

anyone?

If you move the files to a different location, I believe you will have to do some work to get it to start back up correctly as the file locations...

Thanks for the clarification. Can't help you, though. Since you can't connect to a 2000 server from 7 EM, my client was upgraded with my first server.

In short, no. Due to the way that SQL Server and NT both handle file locks, it is not uncommon for such a disparity with open files.

Don't quote me, but I believe it does put some serious locks on the tables. We had soem developers here do that and we could watch the locks line...

quote:

---

...I just can't see them in the SQL7 EM on my client pc. Anyone run into this one before?

---

Brian Glass
Sr. Database Adminstrator
Bombardier Aerospace