I have faced this problem many times and have developed a very reliable and consistent way deal with...

Jeff Moden (1/23/2010)

---

Where did...

Last sentence of this post?

David Portas (1/22/2010)

---

PaulB-TheOneAndOnly (1/21/2010)

---

All the conventional Normal...

Assuming you are on SQL Server 2005, here is a very simple example of what Lutz was talking about:

SELECT *

FROM INFORMATION_SCHEMA.TABLES

FOR XML PATH

If you execute this with "Results to grid"...

Ah. Then you should have used one...

You might also want to consider changing that TEXT field to a VARCHAR(MAX) as Microsoft recommends.

Heh. Well, all but one ... 😀

Why not? It's perfectly safe as long as you do it correctly.

Here is how I would do...

Bhuvnesh: Please stop posting your code without the [ code ] formatting tags, like this:

Bhuvnesh (1/19/2010)

---

GO

CREATE TABLE dbo.PENDING_ANSWER_FILE

(

acct_id dbo.ut_synthetic_key NOT NULL,

qstn_stub dbo.ut_stub NOT NULL,

entity_stub dbo.ut_stub NOT NULL,

evt_stub dbo.ut_stub NOT...

ALZ: Well, you know the drill :-), we'll need to see the sending code, the receiving code, the SB definitions and the definitions of any tables touched by the...

RBarryYoung (1/21/2010)

---

SQLPirate (1/21/2010)

---

The client_net_address should represent the address of the client machine making the connection. If you're connecting directly from your machine it should show your address. If you're connecting...

SQLPirate (1/21/2010)

---

The client_net_address should represent the address of the client machine making the connection. If you're connecting directly from your machine it should show your address. If you're connecting through,...

This a SQL 2005 forum and what you are pointing to is merely the SQL 2000 version of what Paul has already provided a link to.

Pedro DeRose [MSFT] (1/21/2010)

---

Here are a couple of key use scenarios for SQL CLR:

...

2. Streaming results of TVF: T-SQL table-valued functions materialize their results in temp tables, whereas CLR...