Re: Using fields with Text 'datatype'
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
There may also be some other/better ways to do this; perhaps DTS, etc?
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:
>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
>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.
>*** Sent via Developersdex http://www.developersdex.com ***