In 80 compatibility when you have alias for derived column that is same as column name, the prefix is ignored in the order by statement and the order is done...

I think it works... seems OK to me. Yes showcontig only gives the table name back but its uses the object ID to run the defrag

DBCC INDEXDEFRAG (0, '...

Yep, its the bottom section of where you define the report parameter.

see http://www.sql-server-performance.com/articles/reporting/report_parameters_p1.aspx

For maintenance plans, goto Management & Right click on Maintenance Plans, then click on View History

For jobs, goto SQL Server agent, right click on Jobs folder and click view history.

--

Or...

It looks like you can just replace this code

with this

DECLARE tables CURSOR...

They will have the same permissions because the sp_help_revlogin script creates the accounts with the same SID & password. SQL accounts will map properly, and domain accounts have...

deleting a bit at a time might help you. Say you have 2 years worth of history (730 days), delete 2-4 weeks at a time..

sp_delete_backuphistory (#days to keep)

so find out...

TUF Believe that would be "Transaction Undo File"

I usually take this approach for moving databases. I never move entire instances and mess with restore system databases because of the risk of instability.

> change db's to single...

Another article to follow on your maintenance jobs and how the testing went?

Nice article!

I almost went 3,3,3 then took a look at the data types again before submitting .. tricky 🙂

anything in the application log when trying to start the service?

you could access it directly instead of using openquery..

update SERVERLINK.DATABASE.SCHEMA.servercollection

set username = 'TEST'

where hostname = 'TEST'

select *

from SERVERLINK.DATABASE.SCHEMA.servercollection

I always have...

Yes, but please don't take this as criticism. I love these articles you guys write, and just wanted to add a note as I've done something similar before 🙂