Error Catch fail when comparing Views with Except statement

Question

We are in the process of switching servers (Sql Server) and we would like to compare our Views between the servers for differences. Comparing the Views via Except works fine however I'm having difficulty catching the error with the below code. I tested with a simple 1/0 to make sure an error could be captured: I'm wondering if I'm missing something:

    Begin Try
       Select * From [Server1].[database].[dbo].[View_Name]
    Except
       Select * From [Server2].[database].[dbo].[View_Name]
    End Try

    Begin Catch
       Select
          Error_Message() as Error
          Error_Line() as ErrorLine
    End Catch

question from:https://stackoverflow.com/questions/65905621/error-catch-fail-when-comparing-views-with-except-statement

Answer 1

Waitting for answers