Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nomaneagle
Starting Member
18 Posts |
 Posted - 2008-12-11 : 09:20:26
|
| I am trying to create a log of all of my exceptions which are produced due to the connectionstring problem and fails system to get connected with the database:So the scenario is select case sqlExceptionCodeCase 17, 18456, 4060 Write Exception to Event LogCase Else Write Exception to Database TableThis code works fine with exception code 17,18456 and 4060. But I have been told that there are many other sql exception codes which are produced due to the connectionstring. Can I get a complete list of all those codes so that I can check them in my class? |
|
|
Amjad Islam
Starting Member
1 Post |
Posted - 2008-12-24 : 03:23:01
|
| i have a date base in which using, 3 colume 2 for dates and 1 for difference of 2 dates but i want to use the computed column formula that sql dynamically use the fomula and add it in to data base. i don't was to get and post the difference through codes.Amjad Islam Khan |
 |
|
|
ayamas
Aged Yak Warrior
552 Posts |
Posted - 2008-12-25 : 02:42:50
|
quote:
Originally posted by nomaneagle
I am trying to create a log of all of my exceptions which are produced due to the connectionstring problem and fails system to get connected with the database:So the scenario is select case sqlExceptionCodeCase 17, 18456, 4060 Write Exception to Event LogCase Else Write Exception to Database TableThis code works fine with exception code 17,18456 and 4060. But I have been told that there are many other sql exception codes which are produced due to the connectionstring. Can I get a complete list of all those codes so that I can check them in my class?
Use MasterSELECT * FROM sysmessages where msglangid=1033 |
|
|
|
|
|
|
Sql Exception Code