Be aware that on SQL Server 2005 Standard, index rebuilds will only utilize a single processor. They will never use a parallel plan.

SQL Server 2005 Enterprise Edition can (and...

I have to agree with Tim here - you are missing something from the application. Could be a monitor process, a scheduled job - or even a user that...

Can you access the D drive on the server? Can you navigate to the folder where the mdf/ndf/ldf files exist and verify that they do in fact exist?

I have...

I am happy that you got it working - thanks for the feedback.

Based upon your sample data - you don't have a primary key. The examples given here don't include a primary key definition.

For either solution to work - you need...

Lynn Pettis (4/8/2009)

---

Goldie Graber (4/8/2009)

---

That won't work, Lynn. It doesn't take into account consecutive blanks.

For example if I use the following data, I still expect 1 as the answer but...

FlyFish-N-Lady (4/20/2009)

---

I can log on with either Windows Authentication or SQL Server Authentication. Did not see a setting for both. LANDesk must use a SQL account to access the database.

I...

That procedure, by itself - is not the problem. That procedure executes a sql command that is dynamically built.

You can look in books online to get more information on...

When you installed SQL Server, did you change from Windows Authentication only to both SQL and Windows authentication?

The recommendation is generally anything with less than 1000 pages doesn't need to be rebuilt/reorganized. Of course, you are going to need to test that in your own environment.

The...

I am just curious, but why would someone need to drop a work-table on a regular basis?

You want to look at the new syntax to alter an index:

ALTER INDEX index ON table DISABLE;

You can use sys.indexes, sys.tables and sys.partitions to identify the appropriate indexes to disable...

That makes sense - since, as a sysadmin the default schema is overwritten to 'dbo'. SQL Server checks the default schema (now dbo because of sysadmin), then checks the...

Thanks for the feedback - I hope that was the problem and that it is now fixed.

As was asked earlier - why do you need to rollback? Are you having a specific issue that SP3 broke?