Then the failure was from one of the later tasks. You need to log the output of the maintenance plan to tell exactly where.

btw, why on earth are you both...

I wouldn't recommend it. Not for any of the system databases.

Not...

What's in the error log? CheckDB results are logged to the error log, so you should be able to see what ran.

Do you have the maint plan logging output to...

Does the operating system see the CPU?

Have you rebooted since adding the CPU? I don't think that 2005 standard edition supports hot-add of processors.

I'm going to give unpopular advice.

Store the data in a properly normalised table design, with each piece of data in a column with an appropriate data type, tables fully normalised...

You can't. If I recall (and this needs to be checked preferably with Microsoft),...

What exactly do you mean by Record ID? What...

kingscriber (1/18/2010)

---

What I think you are trying to get me to see is that isolation level and lockModes are two different "entities". However they do effect each other, but not...

Sure I can.

I assume you're not just asking if I can, but would like said explanation? 😉

Whenever a DDL statement is executed in a batch, the execution...

Never heard of a downgrade option, I'd just uninstall SQL 2008 and install SQL 2005. Honestly, that portion is the least of your problems.

The biggest problem here is that there's...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic849141-391-1.aspx

Yes.

shanu.hoosen (1/18/2010)

---

The answer is simple. you do have a clustered index(Primary Key) on the key column. SQL will store data based on this column.

If i have to alter your create...

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/