470,638 Members | 1,642 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,638 developers. It's quick & easy.

How can i get the details of the error

How can i get the details of the error in sql server 2000 such where it
occurs in which line. I need something like i get in sql query analyzer.

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #1
4 882
E B via SQLMonster.com (fo***@nospam.SQLMonster.com) writes:
How can i get the details of the error in sql server 2000 such where it
occurs in which line. I need something like i get in sql query analyzer.


In SQL 2000, the only item you can find out about an error is the
number of the error.

In SQL 2005, currently in beta, there is a vastly improved support in
this area.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2
Thanks, however what can you advice me??

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #3
E B via SQLMonster.com (fo***@SQLMonster.com) writes:
Thanks, however what can you advice me??


Since I don't know what you are after, it's quite difficult to give any
advice.

However, I have two articles on my web site on error handling in SQL Server.
They may give you some guidande.
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #4
ok thanks

--
Message posted via http://www.sqlmonster.com
Jul 23 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Philipp Schumann | last post: by
3 posts views Thread by Paul Cheetham | last post: by
1 post views Thread by Korara | last post: by
???
1 post views Thread by Stoney L | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.