Hi,

   Thx for the reply. I tried it and here's a sample of that.

Scan:Stopped 2 190623722  Microsoft Office 2000  x63880  0   500 304 2006-

02-07 13:12:08.170 

1) Why isn't the TextData appearing ?

2) This output still does not answer my...

I am still not clear on what options do I choose on sql profiler to see what tables or indexes are going for a full scan.

What do I need to...

Hi

Where would I find the "Page Life Expectancy Counter" to set ?

TIA

Mo

Where do i get unix ODBC ? We run sun solaris 8

TIA

using TCP/IP