Re: Sys SP

From: Wayne Snyder (wsnyder_at_computeredservices.com)
Date: 03/19/04


Date: Fri, 19 Mar 2004 10:02:42 -0500

The authoritative way to discover this kind of thing is to use Profiler as
Tibor says, but I think it uses Dbcc inputbuffer..

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"MAT" <anonymous@discussions.microsoft.com> wrote in message
news:100a301c40da4$7813fcf0$a501280a@phx.gbl...
> Does anyone know what System Stored procedure or what code
> is executed when you view the last 'TSQL Command Batch'
> from the current activity/process info screen in EM?


Relevant Pages

  • Re: SQL DB Design Tool
    ... "Wayne Snyder" wrote in message ... > Wayne Snyder, MCDBA, SQL Server MVP ... >> Mark Broadbent ...
    (microsoft.public.sqlserver.server)
  • Re: Time range matching
    ... > datetime with a time range that spans multiple days... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: Add new column to a replicated table..
    ... "Wayne Snyder" wrote in message ... > Sp adds the column to the table, and fixes replication... ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.programming)
  • Re: How to know the table size in sql database and how to know whi
    ... each table during the iteration that happens within the stored procedure. ... > Wayne Snyder, MCDBA, SQL Server MVP ... > community of SQL Server professionals. ...
    (microsoft.public.sqlserver.server)
  • Re: How to learn .Net
    ... > Wayne Snyder, MCDBA, SQL Server MVP ... > Mariner, Charlotte, NC ... >> I read everywhere at the moment that SQL Server professionals need to ...
    (microsoft.public.sqlserver.server)