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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 exceptions info

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-11 : 06:47:57
Vikas writes "can any one help me in getting the list of exceptions and there types and how to tackle them."

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-11 : 10:24:14
you mean the error messages that can be returned by sql server? they are stored in sysmessages, in different languages.

to see just the english ones:

select * from sysmessages where msglangid=1033
and severity >= 16

EDIT: however, you can't hope to handle all these - most of them you would never see anyway.


www.elsasoft.org
Go to Top of Page
   

- Advertisement -