Get the Status of the sql query

[tonan]

Hi,

I wanted to trap the message which is returned when you execute a query in the query analyzer window of sql server.

Like " command completed succesfully"

How to trap this message from the sql server that your commands have been executed with or without errors from your program. Does the sql DataAdapters have any methods which can let you do it. Please let me know kind a urgent.

Thanks in advance