Sounds more like an issue with their application than a problem with the sql native client to me. However, you might be better off following their recommendation for their...

Resources used. Your code has to create a temporary table, populate it using a loop using...

dwain.c (4/2/2012)

---

Lynn,

How about this case?

DECLARE @n TABLE (n INT)

INSERT @n (n)

SELECT 5

UNION ALL SELECT 1

UNION ALL SELECT 4

UNION ALL SELECT 2

UNION ALL...

Too...

please read and follow the instructions in the first article I reference below in my signature block regarding asking for help. It will walk you through what you need...

Welsh Corgi (4/2/2012)

---

I had found another article similar to this.

I got an error...

Where is the matrix? And I'm not talking about the movie(s). 😛

I would be curious the value for is_broker_enabled in sys.databases for this database.

With nothing to use for testing, here is a shot in the dark:

create function [dbo].[itvf_GetGeoDistance] (

@inLon1 float,

@inLat1 float,

@inLon2...

Lowell (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

SSIS shouldn't have anything to do with Database Mail.

What has me slightly confused is you talk about using Database Mail, but the code you show is using...

SSIS shouldn't have anything to do with Database Mail.

What has me slightly confused is you talk about using Database Mail, but the code you show is using CDONTS. I...

No. To ensure order you need an ORDER BY clause.

And to ensure order by the id column, you need to include an ORDER BY id in your query.

GilaMonster (4/2/2012)

---

Evil Kraig F (3/30/2012)

---

GilaMonster (3/30/2012)

---

I read the end of that and I am not getting involved...

Initial gut feel - improper transaction management (leaves transactions open) combined with connection pooling....

GilaMonster (4/2/2012)

---

Lynn Pettis (4/2/2012)

---

It was my understanding that the compressed data was backed up as is, and by using page or row compression you would not be able to restore...