Problem with Compare2Tables Script from Preethi

  • dba_user

    Default port

    Points: 1458

    I am working on a script on comparing all the tables in two different databases. I found the Compare2Table (Updated) script and it's crashing with image and ntext fields in the tables saying it can not be used with DISTINCT. I cannot seem to find the problem.

    Please help!

  • This was removed by the editor as SPAM

  • G.R.Prithiviraj Kulasingham

    SSCarpal Tunnel

    Points: 4104

    The script uses SELECT DISTINCT and you can't use blog columns in comparing. It means you need to exclude them: Use the @Fields parameter to list the other columns.

    Cheers,
    Prithiviraj Kulasingham

    http://preethiviraj.blogspot.com/

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply