Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

6232B_12 Handling Errors in T-SQL Code: Types of Errors

Hi experts, i am reading about  Types of Errors but i do not understand
Connection Terminating Errors
and
Server Terminating Errors
and
Statement Terminating Errors


can you give me an example of when these errors occur?
0
enrique_aeo
Asked:
enrique_aeo
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
enrique_aeo, as it appears you are studying for certification or some other course, it would be best to ensure you learn this to the fullest; therefore, I will provide a reference to MSDN on Database Engine Error Severities: http://msdn.microsoft.com/en-us/library/ms164086.aspx. Further, think about what the word "terminating" means. View connection, server, and statement as scopes which get terminated.

Please read through the documentation along with my hints and post back you understanding of each if there is a still a doubt. We will guide you from there.

Hope that helps!

Kevin
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now