Sounds feasible but when I try this I get "The operation could not be performed because the OLE DB provider 'OraOLEDB.Oracle' does not support distributed transactions." and am not sure...

Also check out http://support.microsoft.com/default.aspx?scid=kb;en-us;Q319698 which has a statement on SQL 7 that is fixed with SP4.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston...

Can you post an example of a string and how you setup your connection, command, and recordset objects?

"Don't roll your eyes at me. I will tape them in place." (Teacher...

How are you controlling the while flow. I see nothing that would cause rowupdate to become 0 and see no reason for it. DO you get the same tempdb problem...

Are you touching another machine. As when the DTS package is run as a job it runs in the context of the accout for SQL Server Agent which unless you...

Epol if I understand you right then thru a cursor or While loop. You cannot use call a procedure in a SELECT statement.

"Don't roll your eyes at me. I will...

I will have to dig at work but what Andy states sounds right about a DSN or UDL, those things always give us trouble when moving the Excel file to...

Try REGSRV32 on the dll with -u and regular to reset it in the registry.

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

See if this looks like it may be your issue. http://support.microsoft.com/default.aspx?scid=kb;en-us;Q232196

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I from past speaking with other folks do not believe you can restore a 6.5 database without knowing the device history to make sure the restore is done in a...

First what are you seeing that makes you believe that there is a memory leak?

Next if you are trying to find bad queries then Profiler will be your best freind....

Are you getting an error or is it just not lauching?

"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

I have never seen this work and do not believe you can do it directly. You might could setup a SQL server to act as mediate by pulling the data...

Sounds beefy but those statistics may show a bottleneck somewhere causing it to do this. Let us know what you find. You may also want to setup Profiler to do...

If the view is used in the trigger then yes. However external to the trigger in another user session it may not unless they are set to allow uncommited reads,...