DTS - Problem with Image field

DTS is not properly exporting a database between the servers when a table is containing a image field

Reason it gives as

::Error::
Transfer Status: Transferring Data: (Table '[dbo].[Here comes the table name used ]')
Data truncation occurred in table [dbo].[Here comes the table name used ], column 1.

any workaround or solutions would be more appericated

any help would be more appericated and important to find a solution

|||

Maybe there is some image data larger than 8388602 bytes being transfered using Copy SQL Server Objects task, in this case try Import/Export Wizard instead.

And there are some other considerations you should take when using DTS to transfer BLOB data (image, text, ntext), please take a look at:

Data Conversion and Transformation Considerations

|||

that is excatly the problem , DTS truncates BLOB data and shows the error.

But how to resolve it , Iam using sql server 2000 and win xp in local server.

is BLOB data is still a issue in sql server 2000 or it is solved.

|||If you use Import/Export wizard to transfer the BOLB data (you can also save this taks to DTS package), will the same error be raised?|||

Import/Export Wizard will go to DTS package only .

Ok.

What is the command to find the sql sever installed in the system and the service pack?

Help would be appericated in getting the command

|||

Try T-SQL command:

SELECT @.@.VERSION

|||

It is showing in the sql query analyser

I wanted the command to be executed in the command prompt

and how to know the version of sp installed in the system

|||Then how about to exeute the T-SQL command in osql in command prompt|||

Can u give me the exact command.

What is the star which appears on left side along the thread

|||

Ganesh@.Nilgris:

Can u give me the exact command.

osql is a command-line utility which allows you to execute T-SQL commands So just start osql in command prompt then type T-SQL command as you can do in Query Analyzer and remember to enter "go" to submit a batch:

C:\Documents and Settings\Administrator>osql -E
1> select @.@.version
2> go

-----------------

---------------

---------------

---------------

--
Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86)
Apr 14 2006 01:12:25
C
opyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Wind
ows NT 5.2 (Build 3790: Service Pack 1)

(1 row affected)

|||

Thats was a good one, It was usefull in learinig sql commands in cmd prompt

But how do u still find the service pack .

DTC

Does anyone have any instructions on how to setup the MSDTC properly and
make it work with all the security updates. I am trying to communicate
between to windows 2000 machines and I am getting:

Error 8524
The current Transaction could not be Exported to the Remote Provider.

The distributed transaction works fine on to instances of SQL Server 2000 on
the same machine.

RandySorry Correction

I am running on XP SP2 and trying to establish a transaction with Windows
2000 Server SP4.

"Randal" <rfraser@.novaflow.com> wrote in message
news:X8q5g.497$VV2.39662@.news20.bellglobal.com...
> Does anyone have any instructions on how to setup the MSDTC properly and
> make it work with all the security updates. I am trying to communicate
> between to windows 2000 machines and I am getting:
> Error 8524
> The current Transaction could not be Exported to the Remote Provider.
> The distributed transaction works fine on to instances of SQL Server 2000
> on the same machine.
> Randy