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
1.4m articles
1.4m replys
5 comments
56.9k users