If a failure occurs, we do need to roll back the entire batch of changes to the last known good state. Your suggestion regarding named transactions is a good...

We ingest an XML string, and depending on parsed values, pass the string to one of several child procedure for further parsing and processing.

We use xpath to parse an...

i'm sorry, i have to learn to hit the preview button. That doesn't look right at all. Let me try again.

Thanks Steve for your reply.

I hope the following information answers your questions:

We ingest an XML string, and depending on parsed values, pass the string to one of several...

So, while the rollback strategy works just fine, if the trancount is 2-3 or more, we get the following error:

Msg 0, Level 11, State 0, Line 0

A severe error occurred...

sorry, i wasn't done yet! I will finish post in next post!

That was the problem. We didn’t update our reg values ( HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI ) when we installed the Oracle 9i client

BEFORE:

OracleXaLib = xa80.dll

OracleSqlLib = SQLLib80.dll

OracleOciLib = oci.dll

NOW:

OracleXaLib = oraclient9.dll

OracleSqlLib =...

Yes, we have the Oracle 9i client installed on the SQL Server 2000 machine.

Here is the error:

TITLE: Microsoft SQL Server Management Studio

------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For...

We are having a similar problem. Trying to create a linked server in SQL2000, to an Oracle server, using the MSDAORA.DLL as the OLE DB provider.

Here is our error...