July 15, 2008 at 2:31 pm
Hi,
I have binary executable that is executing queries against my database. I am trying to get a list of queries being sent by this binary to my SQL server. Does anybody have any recommendations on how to go about it?
Thanks,
Mo
July 15, 2008 at 2:41 pm
Run a trace (Profiler can help with that). Books Online has all the data on setting that up.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 16, 2008 at 3:48 pm
As a rule, you can easily monitor data changes in SQL Server: insert, update, delete. But there's no easy way to see who is looking at what. A trace, as GSquared said, is going to be the way to go.
Though another way occurred to me. If you used stored procedures to query data, i.e. the compiled program passed parameters to a SP which then returned a result set, then you could put some logging in the SP.
-----
[font="Arial"]Knowledge is of two kinds. We know a subject ourselves or we know where we can find information upon it. --Samuel Johnson[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply