Solved

list of sqlexception numbers for mssql to be used in C#.NET

Posted on 2013-11-25
4
1,458 Views
Last Modified: 2013-11-27
Hi;

I need the list of sqlexception numbers for mssql to be used in C#.NET.

Regards.
0
Comment
Question by:jazzIIIlove
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
Brian Crowe earned 250 total points
ID: 39675412
SELECT * FROM sys.messages
WHERE language_id = 1033
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39676892
what happened to 1-20 and 22-100?
0
 
LVL 12

Author Comment

by:jazzIIIlove
ID: 39676894
furthermore, if i have an SQL exception, then will those message appear or a generic message will be coming in C#.NET?

regards.
0
 
LVL 75

Assisted Solution

by:Anthony Perkins
Anthony Perkins earned 250 total points
ID: 39679672
then will those message appear or a generic message will be coming in C#.NET?
It really depends on your coding abilities.  If you do it correctly you would get the same error message as you get in SSMS.  So there is no need for a list of error messages.  They are dynamic and are based on the language.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question