Re: Queries Fired

From: BP Margolin (bpmargo@attglobal.net)
Date: 11/27/02


From: "BP Margolin" <bpmargo@attglobal.net>
Date: Wed, 27 Nov 2002 14:05:43 -0500


Abhijit,

Check out the documentation on the SQL Server Profiler in the SQL Server
Books Online.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Abhijit" <cosltemp.abhijit@citicorp.com> wrote in message
news:1989601c295ed$05293690$89f82ecf@TK2MSFTNGXA01...
> Hi All,
> Could someone tell me how do I get the queries fired at
> the database? Is there a log which allows me to see those
> queries?
>
> How do I view this?
>
> Thanks & Regards,
> Abhijit



Relevant Pages

  • Re: query plan in clear text
    ... Personally, I do almost all tasks from Query Analyzer, and about the only ... Enterprise Manager is to deal with jobs. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Interpreting the execution plan results
    ... > On Query Analyzer.. ... > I can figure out a little what the information on the execution plan means ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Server needs help from MS Access (or something)
    ... unlike the query analyzer, which allows you to run code, and then just ... is a tool for writing applications, EM and QA are developer/admin tools. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Debugging Stored Procedures with Query Analyzer
    ... When trying to debug a stored procedure with query analyzer it does not ... SQL Server is on the same machine. ... First check in Help->About in Query Analyzer which version of QA you have. ... Books Online that may give further tips. ...
    (microsoft.public.sqlserver.tools)
  • Re: Format a datetime columns output?
    ... To add to David's reply, if you are using Query Analyzer for output, ... so that the user's regional settings can be ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)