[Top] [All Lists]

Re: Using fields with Text 'datatype'

Subject: Re: Using fields with Text 'datatype'
From: Joe Webb
Date: Wed, 31 Aug 2005 17:58:20 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Yogesh - 

As you've already discovered, the Text datatype is not supported in
SQLNS for the reasons that Andy mentioned. 

As a workaround, can you send a notification to the remote server that
indicates that it should connect to your instance and pull the text
field across? 

There may also be some other/better ways to do this; perhaps DTS, etc?

Joe Webb
SQL Server MVP

Get up to speed quickly with SQLNS 

I support PASS, the Professional Association for SQL Server.

On Wed, 31 Aug 2005 08:02:53 -0700, Yogesh Kadalgikar
<[email protected]> wrote:

>Hello Andy,
>Thanks for the reply. No I am using SQL Server 2000. The notification
>service is installed as a seperate component. 
>As I have a requirement, I need to push the information stored in my
>local database as Text to the another Database remotely. I am using
>Notification service. 
>Yes the information crosses more than 8000 characters so I cannot put it
>as VARCHAR too. 
>Please shed some light as to what is a workaround for this problem. 
>Yogesh Kadalgikar 
>*** Sent via Developersdex ***

<Prev in Thread] Current Thread [Next in Thread>