Thanks Grant.

Grant. If I may burden you again. What table in the msdb would contain the backup file name created by the maintenance job?

Thanks Grant. Great idea. Didn't think of accessing the backup file name from msdb. If I get your drift I should be able to insert it into the restore statement?

Thanks to everyone for taking the time to respond.

Thanks for the followup Jeffrey. Per my previous, I can't install the SQL 64 'cause I don't have the media on site, and I'm in a rush... " there's frequently...

Thanks Jeffrey. Are you saying that the 32 bit SQL version ("...your applications..." ) can access the same memory amount as the 64 bit version, and also have similar...

Thanks fhanlon and Steve. It's good to know we're not alone.

Thanks for the response Steve. Can't answer that question. Anyone know?

David, are you saying Reporting services fails with the 32 bit SQL but RS was successful running on the 64 bit 2005 SQL?

Thanks for responding David. We' re in a money and time crunch, and need to implement this configuration this morning. Eventually we will purchase the 64 bit and implement.

Here's the error...Thanks for helping:

ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server] The operation could not be performed because the OLD DB provider 'SQLOLEDB' was unable to begin a distributed transaction.

[Microsoft][ODBC...

Thanks for replying. A select fails.

All services run under identical service accounts

Exactly... it's not there.

Thanks Jeffrey! You nailed it. The sqlwb.exe launches SSMS. It doesn't show as a selection on the drop down menu. Would you know why?