Discussions Search    Reviews    Stream    Buzzzz    Google@Omgili    Q&A    Health    Directory    Categories Add to iGoogle   Bookmark and Share

Refine the results by clicking on a Category

Omgili, forum search, forums search, search forums, discussion search,discussions search, search discussions, board search, boards search, search boards
  Advanced Search

how can export activity monitor process info data to txt or csv ?

On Wed, 11 Jun 2008 15:12:54 +0800, "Ken" <...@yahoo.com.hk

as title , anyone know , thank a lot




On Wed, 11 Jun 2008 15:46:23 +0800, "Ken" <...@yahoo.com.hk

sorry, in sql server 2005, i can export in sql 2000

"Ken" <...@TK2MSFTNGP06.phx.gbl...


On Wed, 11 Jun 2008 14:53:58 -0700, Erland Sommarskog <...@sommarskog.se

Ken (ke...@yahoo.com.hk) writes:

There does not seem to be any option, and neither is there with the new
Activity Monitor in SQL 2008 RC0.

If you think this is essential, file a suggestion on
http://connect.microsoft.com/SqlServer/Feedback

In the mean while, you may be interested in my beta_lockinfo, which you
run from a query window, and which gives most of what you get from
Activity Monitor, if not more.
http://www.sommarskog.se/sqlutil/beta_lockinfo.html


--
Erland Sommarskog, SQL Server MVP, esqu...@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 Latest discussions from this group  (microsoft.public.sqlserver.tools)
Performance problem  
[30 Jun 2009]
On Tue, 30 Jun 2009 12:52:02 -0500, "Mark Goldin" <mgoldin@UFANDD.L OCAL I have a problem...
with a production SQL box. The problem is that once or twice a day the box is getting...
SQL Server Management Studio Express  
[26 Jun 2009]
On Fri, 26 Jun 2009 08:31:02 -0700, scuba19 <scuba19@discussi ons.microsoft.com I have...
installed on a user the SQL Server Management Studio Express console and they have...
How to bcp in fixed position data while skipping certain positions  
[25 Jun 2009]
On Thu, 25 Jun 2009 10:01:01 -0700, Snake <Snake@discussion s.microsoft.com I have a ...
txt file I have to bcp in. The file contains fixed-position columns of data but there is ...
More...