Table Scans

Table Scans

 

  

Hello,

I'm running SQL server 2000 sp4 and wondering if it's possible to identify which tables are being scanned without profiling? Any ideas?

Thanks


MS Sql Server LazyDBA home page