Query Analyzer?

Experts,
I have a standard SQL 2000 installed onto a Windows 2003 Server on which I
am a local administrator. An IIS server by way of ASP.NET uses this SQL
database server as it's back-end. Someone told me there is a way in SQL to
see who is using the database via the ASP>NET front-end on the IIS server.
Something called Query Analyzer I believe. How do I get to that in SQL? I
am such a SQL novice that I'm afraid I'll need the exact steps to click to
fire this thing up. :-)
Spin
Query Analyser is a query tool that comes with SQL Server 2000 (as part
of Microsoft's "client tools"). You run it from the Start menu (Start |
All Programs | Microsoft SQL Server | Query Analyzer).
However, just running QA (Query Analyser) probably won't help you as you
need to know what queries to actually run in QA to get the info you're
after (and it doesn't sounds like you're quite that advanced, no offence
intended). Running
exec sp_who2
in QA will probably tell you what you need to know but there is a
graphic tool in SQL Server Enterprise Manager that will show it to you
in a GUI, which will probably be much more user friendly for a novice.
To start SQLEM (SQL Server Enterprise Manager) run it from the Start
menu (Start | All Programs | Microsoft SQL Server | Enterprise
Manager). Then expand the tree in the left pane to the local server.
Expand the + for the server (it may ask you for login credentials if you
haven't saved them when registering the server in SQLEM). Then expand
Management | Current Activity and click on Process Info. The right pane
will then contain essentially the same info as you'd get from executing
"exec sp_who2", more or less, but in a more user friendly format.
Hope this helps.
*mike hodgson*
http://sqlnerd.blogspot.com
Spin wrote:

>Experts,
>I have a standard SQL 2000 installed onto a Windows 2003 Server on which I
>am a local administrator. An IIS server by way of ASP.NET uses this SQL
>database server as it's back-end. Someone told me there is a way in SQL to
>see who is using the database via the ASP>NET front-end on the IIS server.
>Something called Query Analyzer I believe. How do I get to that in SQL? I
>am such a SQL novice that I'm afraid I'll need the exact steps to click to
>fire this thing up. :-)
>
>
|||You are the MAN!
Spin
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message
news:%23QZkJwbNGHA.3272@.tk2msftngp13.phx.gbl...
> Query Analyser is a query tool that comes with SQL Server 2000 (as part
> of Microsoft's "client tools"). You run it from the Start menu (Start |
> All Programs | Microsoft SQL Server | Query Analyzer).
> However, just running QA (Query Analyser) probably won't help you as you
> need to know what queries to actually run in QA to get the info you're
> after (and it doesn't sounds like you're quite that advanced, no offence
> intended). Running
> exec sp_who2
> in QA will probably tell you what you need to know but there is a
> graphic tool in SQL Server Enterprise Manager that will show it to you
> in a GUI, which will probably be much more user friendly for a novice.
> To start SQLEM (SQL Server Enterprise Manager) run it from the Start
> menu (Start | All Programs | Microsoft SQL Server | Enterprise
> Manager). Then expand the tree in the left pane to the local server.
> Expand the + for the server (it may ask you for login credentials if you
> haven't saved them when registering the server in SQLEM). Then expand
> Management | Current Activity and click on Process Info. The right pane
> will then contain essentially the same info as you'd get from executing
> "exec sp_who2", more or less, but in a more user friendly format.
> Hope this helps.
> --
> *mike hodgson*
> http://sqlnerd.blogspot.com
>
> Spin wrote:
>