select * from sysmessages
what is common parameter on which I can identify that this is relavent error message in the list,also is there is any solution list also available?
When an error occurs, SQL server offers you the error message along with errorcode (corresponds to an entry in sysmessages).
All error messages have their relevance - they are errors after all ;-)
If you are facing a specific issue, then I suggest that you look here or on your favourite search engine for possible solutions to that problem.
Looking for solutions to problems that are included in sysmessages may not be the best use of your time.
answered Jul 21, 2010 at 12:34 AM
First of all, sysmessages contains messages in many languages.. For English you can filter them by mslangid = 1033.
Also messages with severity 10 is always error.
But to search for possible errors and their meaning for particular operation or command, take a look in the BOL. There are mostly described scenarios which leads to errors.
answered Jul 21, 2010 at 01:02 AM
Thank you pavel for your help again,I have already given you one thumbs up,please let me know if you have any email id,great to keep in sync with you.
answered Jul 21, 2010 at 02:04 AM
Assuming you're looking at the SQL Server Error Log for the messages, you should see two messages per incident - one giving the error code, severity and "state", and the other giving a more detailed description.
If you're not looking at the SQL Error Logs, but just at the error message returned to your application, then have a look at the SQL Error Logs. They do (sometimes) have the answers. if you need some code to do that programmatically, then just ask!
answered Jul 21, 2010 at 01:32 PM