It was. I did the exchange rate calc in my head and messed...

From the sound of the error, there's corruption in the transaction log. Drop the affected databases and reconfigure log shipping for those DBs from scratch.

Also, do some checks of the...

Lynn Pettis (5/27/2010)

---

GilaMonster (5/27/2010)

---

More free consulting? http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx

Anyone keen and free?

I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look at...

There's no bulk-encrypt option, objects have to be encrypted with an ALTER statement. Maybe a tool like Redgate's SQL Refactor could do it for you, or you could write something...

I usually charge around $1250-$1500 per month for something like this (one analysis and report a month, minimum duration 6 months). If you're interested, PM me and I'll send you...

Ow.

And please do tell how you plan to drop TempDB?

You're perfectly correct. The only service pack that I'm aware of that's not cumulative is Vista SP 2. Requires SP1 first.

Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

More free consulting? http://www.sqlservercentral.com/Forums/Topic928775-149-1.aspx

Anyone keen and free?

I don't mind deadlock questions (though they're often a fair bit of work), but this looks like a general 'look at the trace and...

Worser.

Both options should work fine. Without seeing the code you ran and the error that you got, I can't tell you why it didn't work.

Objects are stored in individual filegroups. If there are multiple...

If it's a datetime, store it as a datetime. If it's just a date, consider the DATE datatype since you're using 2008.

That way you get data validation (20100231 being...

You can drop or disable the index. Disabling it deletes the entire index tree structure, just leaves the metadata behind. You'll have to rebuild the index to re-enable it.