How to log..... ?

[Raja]

I have written ASP.Net application using Vb.Net. I have written various
routines which primarily process the data using SQL statements
(Insert/delete/update.). Some of these statements are created at run time
depending upon data. It appears some times the application is not creating
valid SQL statements. How to log these SQL statements so that I can trouble
shoot these statements at later stages. Since these statements are spread
across multiple locations it is very hard to write the logging activity
codes all the places. Will the trace points and listeners will be helpful?

Thanks,

Raj

 

[bruce barker]

if you are using SQLServer, use its profiler.

-- bruce (sqlwork.com)

| I have written ASP.Net application using Vb.Net. I have written various
| routines which primarily process the data using SQL statements
| (Insert/delete/update.). Some of these statements are created at run time
| depending upon data. It appears some times the application is not creating
| valid SQL statements. How to log these SQL statements so that I can
trouble
| shoot these statements at later stages. Since these statements are spread
| across multiple locations it is very hard to write the logging activity
| codes all the places. Will the trace points and listeners will be helpful?
|
| Thanks,
|
| Raj
|
|

 

[Raja]

No. It is a legacy system. I am using ODBC driver to connect to the system.
There is no much monitoring possible from legacy database.
Thanks for your answers.
Raja