Author  

Language  

Operating Systems  

A lot of VB Programmers use SQL Server for data storage and Business rules in their
client - server applciations.
As I noticed it is very helpull to see whats going on the SQL Server when one executes
a command, sproc or a regular ad hoc query.
There is a utility called Profiler that comes with SQL Server 6.5 and 7. Here is how it
works and how you can use it from SQL Query Analyser or similar tool.
under master database there is a extended stored procedure xp_sqlTrace that PRofiler
uses. In order to use it you must be logged in as anyone other than SA beacause
SQL Server can not impresonate the security of SA account.
you can look up syntax for this sproc at
http://msdn.microsoft.com/library/psdk/sql/xp_aa-sz_15.htm
I am currently working on my version of "Profiler" in VB, hopefully if I have a little more time
on my hands I will be finished soon.


Hope this tip was helpfull to you
Daniel Nagdimunov