how do you identify the latest record, do you have a timestamp or identity column on the table?

http://www.sqlskills.com/BLOGS/PAUL/post/A-SQL-Server-DBA-myth-a-day-%281230%29-tempdb-should-always-have-one-data-file-per-processor-core.aspx

Run the upgrade advisor for 2008, also test all packages work in their 2005 format, otherwise upgrade them in BIDS 2008, test and redeploy.

The upgrade advisor will tell you if...

what error messages do you get then trying to run the agent?

what patches exactly do you need

http://sqlserverbuilds.blogspot.co.uk/ - details all CU's SP's and download links

Configure DB Mail if not already done so

Lookup sp_send_dbmail in BOL or Google

Declare a parameter which takes in a string, then run your select statements, build up the string and...

Use DB mail and build up a mail via T-SQL and schedule it to run via SQL Agent.

SP4 is the latest, RTM means its been released to manufacturing so is a proper release of the product.

Set the database to offline then set it to online, but will wait till all connections have done what they need to do, or if you specify with rollback waits...

Thanks Lowell, tried them procedures but they fail with an error, cant remember which, will try again and post.

Want to try and avoide DAC as it kicks everyone out and...

Thanks Ed, this is a Dev server which was upgraded to R2 for a reason which no one knows, so to get Dev / Test / Live all in sync...

Managing Transaction Logs - http://www.sqlservercentral.com/articles/Administration/64582/

Accidental DBA Guide - Chapter 8 - http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

The only way to "truncate" your data file would be to delete data, shirnk the file then rebuild all...

Use a case statement which brings the colour code of the project back in the result set then use an expression based on the column to colour in the field.

Something...

You would have to build a second query which uses the global report name parameter and query the report server catalog table for the description column.

pass in your column name instead of the string

select dbo.removealphacharacters (fname) from SomeTableWhichContainsAColumnCalledFname