Tag Archives: error handling

  1. A quick and dirty scan of a list of instances using a dynamic linked server.

    5

    November 12, 2020 by Kenneth Fisher

    Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
    Continue reading

  2. How do I test if a linked server works using T-SQL?

    4

    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    Continue reading

  3. Error handling protip: @@Error resets after the next command

    Leave a comment

    March 30, 2020 by Kenneth Fisher

    The system variable @@ERROR is a quick and easy way to retrieve the error number from the last statement run …
    Continue reading

  4. Custom error messages

    1

    July 24, 2019 by Kenneth Fisher

    I’m sure lots of you have used the function RAISERROR to handle an error caused by your code. The problem …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 3,155 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013