Post reply

Problem with Compare2Tables Script from Preethi

  • January 21, 2003 at 2:32 pm

    #79625

    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!

  • January 24, 2003 at 8:00 am

    This was removed by the editor as SPAM

  • March 12, 2010 at 9:16 pm

    #1133110

    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 2 (of 2 total)

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