borderAndreaVB free resources for Visual Basic developersborder
AndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincani
:: SQL Server Tip - Profiler Utility

Author  

Daniel Nagdimunov

Language  

VB5, VB6

Operating Systems  

Windows 95,98,NT
Tip

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

:: Navigation

Home

Database Management

Previous Tip

Next Tip

:: Search this site
Google
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2017 Andrea Tincaniborder