 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion GroupsGeneralPHPASPPerlColdFusionFlashHTML, CSS, ScriptsBrowsers |
Webmaster Forum / ASP / Database Access / April 2007ADODB Trace transaction
Hi, I need to tune up an application and I'd like to enable sql tracing to see how query are made. I've search around to see how I can do but I've find nothing. I'm using adodb object with a connection string to connect to my sqlserver. > Hi, > I need to tune up an application and I'd like to enable sql tracing > to see how query are made. > I've search around to see how I can do but I've find nothing. > I'm using adodb object with a connection string to connect to my > sqlserver. Use SQL Profiler, which is one of the client tools that comes with sql server.  SignatureMicrosoft MVP - ASP/ASP.NET Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM" Thx, I've found this tools but I was just looking at a method that should be call from the asp code because (except in my case) devlopper do not have access to sql server ! > > Hi, > > I need to tune up an application and I'd like to enable sql tracing [quoted text clipped - 5 lines] > Use SQL Profiler, which is one of the client tools that comes with sql > server. I believe you can use SQL DMO (or SMO depending on the version of SQL you are using) for this. However, this will require installing it on the web server, something which your host provider may frown on. If you wish to pursue that option, you will need to post to a sqlserver programming group. > Thx, I've found this tools but I was just looking at a method that > should be call from the asp code because (except in my case) [quoted text clipped - 9 lines] >> Use SQL Profiler, which is one of the client tools that comes with >> sql server. SignatureMicrosoft MVP -- ASP/ASP.NET Please reply to the newsgroup. The email account listed in my From header is my spam trap, so I don't check it very often. You will get a quicker response by posting to the newsgroup. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.