Hi to all,

I am trying to DTS a table across two servers. The table in both servers
looks as follows:

FirstName nvarchar(50)
LastName nvarchar(50)

When I DTS from server A to server B the international characters like the
accents or tildas are missing from the table on server B. They are either
displayed as funny characters or are missing altogether. However, if through
Enterprise Manager I am insert the correct character, it is retained.

The collation and code pages is the same on both servers.

Any ideas on what might be causing this?

Thanks.