Enumerate all SQL Server Errors?

[localhost]

How can I enumerate all of the TSQL errors that come back from SQL
Server 2000? Are they listed electronically anywhere?

Thanks.

 

[Mike Edenfield]

How can I enumerate all of the TSQL errors that come back from SQL
Server 2000? Are they listed electronically anywhere?

catch the SqlException exception object and read it's Errors collection
-- a collection of SqlError objects.

--Mike

 

[Guest]

Hi,
I have a problem regarding the SQLException.Errors collection.

objCommand = new SqlCommand();
.................

1.
objCommand.ExecuteNonQuery();
//Throws an SQLException with Errors.count = 5

2.
objCommand.ExecuteReader();
//Throws an SQLException with Errors.count = 1

I need the 5 errors in both cases.
Why is the results different?

Regards,
/Daniel