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.comE B via SQLMonster.com (forum@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||Thanks, however what can you advice me??

--
Message posted via http://www.sqlmonster.com|||E B via SQLMonster.com (forum@.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, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp|||ok thanks

--
Message posted via http://www.sqlmonster.com