Powershell + SMO Error Handling Tips

Allen White posted a helpful post on SMO error handling with Powershell. Actually the same concept equally applies to SMO coded in any other .NET language. SMO uses an error object’s InnerException which can be several layers deep and you must traverse the nested InnerExceptions to get to the detailed error message. Related to Allen’s post, Michiel Worries gives us another useful technique to get back full error messages. If you find your Powershell scripts are throwing too generic of a error message, you may find some useful messages in InnerException.
This entry was posted in PowerShell. Bookmark the permalink.