DTS changes row size? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS changes row size?

I do a DTS copy from one server to another and then run same query ( really nasty thing with lots of joins on views…not my code…) but on one server it runs fine, on the other it returns an error stating the maximum row length has been exceeded. Is it possible DTS adds padding etc onto columns when it copies tables using a standard DTS Copy SQL Server Objects task & how would I tell? It appears none of the column types have been changed during the copy from server to server. The database collations are identical. The servers are both SQL Server 2000 SP3A. I was wondering about ANSI PADDING but wasnt sure if this applied in DTS. Any thoughts welcome. Cheers,
Try to set the ANSI PADDING before the query in order to take affect.
Also check MDAC versions between the servers. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.