• the script compares all the databases can i compare just two when i tried to replace the scripts as

    SELECT AREA FROM [dbo.A]

    EXCEPT

    SELECT AREA FROM [dbo.B]

    I get an error as

    Msg 208, Level 16, State 1, Line 1

    Invalid object name 'dbo.A'.

    So i am doing something wrong, what i donot know