Excellent, glad you got it working.

I would like to say I understood what you are doing with it and that it looked like a good solution, but I don't, so...

What do you mean by...

Michael.Gibson (4/8/2013)

---

Hi,

Our organisation has some strict firewall infrastructure in place that prevents us from accessing MS SQL databases from our desktops. In the Oracle world, we have to access...

I wrote it now, so despite Luis excellent answer I am posting it - seems a waste otherwise 😛

-- OP Setup Code --

If Object_Id('TempDB..#Editions', 'U') Is Not Null

Drop Table #Editions

Create...

Can you explain what role #Editions will play in producing the results?

Hi Nemachtiani,

Thanks, that is much more helpful 🙂

I suspect that something is causing the transaction to rollback in the SQL SP, which is causing a problem with the .NET transaction...

Lowell, that code...

Nemachtiani (4/8/2013)

---

Hi Mr. Magoo

Sorry for being "vague" but cannot just post all code for obvious reasons...

I'll check with detail your tip about "byref"...just don't know why the "byval" have been...

I'm not getting this...

Why are you not just doing something like this:

declare @xml xml = '<Codes>

<code id="1">A</code>

<code id="2">B</code>

<code id="400">Z</code>

</Codes>'

select

...

Hi,

It is really difficult from the description of the problem to give any good advice.

I looked at your MSDN forum post and found that to be just as vague.

Can you...

P.M.'d you.

patrickmcginnis59 10839 (4/8/2013)

---

opc.three (4/7/2013)

---

Jeff Moden (4/6/2013)

---

Shifting gears a bit, you've been stressing the auditing aspect of things. What type of system auditing do you currently have setup on your...

You need to hook up the InfoMessage Event on the SqlConnection, and set the property FireInfoMessageEventOnUserErrors on the SqlConnection to True.

Now you can use PRINT and RAISERROR in your SQL...

SQL_Surfer (4/5/2013)

---

I am using the following swtich in BCP.

-w -T -t"|" -r"" -c -q

Seems like one switch is overiding the other. File looks different...

TheSQLGuru (4/5/2013)

---

Personally I prefer to not rely on "hope" to get...