Select the job(s) you want from Management-SQL Agent-Jobs  in enterprise manager

Right click and choose all tasks->Generate script

If it was a long running query it may have an extensive rollback period.

Are there any entries in the OS event-viewer?

Can you connect to the database using queryanalyzer? If so...

Which indexes are currently used by your query (view the queryanalyzer)?

Does the index wizard gives any hints?

select

It could have been that the server was too busy.

Is the user able to open the report now?

A lot of sums

Are there indexes on Population.Postcode, Postcode_boundary.Postcode?

Depending on the uniqueness of B.CD_CODE , is there an index on Postcode_boundary.CD_CODE?

Are the statistics...

if 06/30/3003 was a typo

and date_range in the lookup table is split in 2 fields

it can be something like this

select trans_key.key_id,trans_date,Moneyfield,keylookup.good_key as corrected_key

from test.dbo.trans_key trans_key /*transaction table*/

inner join test.dbo.keylookup keylookup...

not sure if  (t1.statusid > @newstatus  or t1.statusid < @newstatus) performs better.

What are your current indexes?

Is the sql reporting server on the same server as your IIS/SQL server?

The reporting was working fine->what has changed? (Moved from development to production....?)

cheers!

Can you connect to the database using the connectionstring the application uses? (using query analyzer)

database logon failed

Is the application using windows authentication or sql authentication to connect to sql server?

try

USE mytargetdatabase

SELECT TABLE_CATALOG, TABLE_NAME

FROM INFORMATION_SCHEMA.TABLES

WHERE TABLE_NAME = OBJECT_NAME(1852795252)

this site has a lot of info about repairing mdac

It mentions windows xp2 but may work as well for windows 2003 sp1

http://www.macropool.com/en/download/mdac_xp_sp2.html

any size differences between the specific database and the others?

looks you have some database corruption

http://www.mssqlcity.com/FAQ/Trouble/er605.htm