Check if there is a firewall issue betweeen the 2 servers. SSRS requires tcp port 135 and potentially TCP high ports 1024 to 65535 to be open between the...

Those errors are normal. But you may want to check out http://support.microsoft.com/kb/917828 especially if you do not have SP2 installed.

Was AutoClose set to True (1) when this database was part of SQL 2000? If you change the Auto_close of the model databsae to false (0) and then...

try using a CASE statement like

SELECT column_13

, CASE ISNUMERIC(column_13)

WHEN 1 THEN CONVERT(numeric(18,2),column_13)

ELSE 0.00

END

FROM #temp

If you are getting an error please post it

to convert to 0.00 format you need CONVERT(decimal(3,2),[column 13]) oytherwise you will get a Arithmetic overflow error converting varchar to data type numeric. error. 0,00 is 3 digits...

If you are using databasemail then the servername is an SMTP server not an exchange server. You can use exchange is you use the old SQL mail but databasemail...

Using Profiler may be the best way to figure out what is happening. Profiler output can get pretty large so you probably don't want to leave this one for...

More RAM is often welcome by SQL but in SQL 2005 there is no difference between the RAM supported by standard edition and enterprise edition. Both are limited only...

It sounds like the backup chain got broken. I assume this is a test box (since you said it was Developers Edition) and other people have access. If...

I assume the user has EXEC authority to the stored proc in question?

Absolutely. When you are editing this step notice on the left side...

My backup jobs are all done via stored procs or T-SQL so the backup step would be something like:

BACKUP DATABASE.....

If you go to the advanced tab for the step I...

Did you check the Application Log of the Event Viewer?

Check if there is anything in the SQL log at the time that might help. (maybe a restore job??)