Capture sql Statement in SQLServer

[richardtsa]

One of my programs I've written in VB is capturing junk somewhere and only occasionally into SQL Server. I can capture the info as it is going into SQL Server. But I still do not know what the sql statement is, that is causing it. Is there any way to capture the actual statement in Sql Server, so that I can go and look for it in my program.
Any HELP would be appreciated.

 

[MeanGreen]

Try using the Query Profiler and you should be able to capture the SQL Statement.

Hope this helps.