Enumerate all SQL Server Errors?

  • Thread starter Thread starter localhost
  • Start date Start date
L

localhost

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

Thanks.
 
localhost said:
How can I enumerate all of the TSQL errors that come back from SQL
Server 2000? Are they listed electronically anywhere?
Click to expand...

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

--Mike
 
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
 
Back
Top