Are you missing indexes on the PROD server? Try updating the statistics on the PROD server.

I thought the question was how to connect to SQL Server From Oracle.

Are you getting any error messages? If so, please post them. Otherwise no one would really understand the issue you are having.

I would install all of the SQL Server tools on the server. It doesn't hurt anything.

You can load the data into a table and in the stored procedure reference this table. That should work.

You are welcome.

And Jason - Thanks for the correction. I didnt read the earlier response clearly. Overlooked that SQL Server 2000 is also involved.

I prefer the SQL Wayne has printed. That is really cool and simple.

Just refining his first query. The OpenRowSet will look something like this:

select * into #temp from openrowset('MSDASQL', 'driver={Microsoft...

Needless to say, and can't say enough and please don't mind me saying.

Please BACKUP all the databases and copy the backup files to an external media or hard drive...

I don't think it matters, which one is the default instance. It can be either 2008 or 2005. There can be only one default instance and all other named instances...

Jeff,

It will be cool to have this tinyurl thing added to the Reply toolbar. I can see this being used umpteen times to show people how to use Google...

JD is probably right. Send Mail task looks depends on Mail relay. Database mail probably doesnt depend on mail relay. Thats all I can think of.

Talk to your exchange administrator...

Excellent. Posted a problem and the solution.

Thats what Jason is asking.

Do you want the date column in the result set? If yes, what do you want the output to look like?

If you exclude id and date,...

You may have to apply the hotfix again. Hotfix may or may not be part of service pack and it depends on whether such a fix is ready to be...

Awesome. Good find. And thanks for posting back the solution.