Table scans are considered bad in SQL Server. They eat up server CPU time and typically can't be optimized. Can you provide more details about what you are trying to do?
>Hi,
>
>I would like to write a script to scan all databases in SQL Server and check a certain table(s). Is there a command in TSQL like FOR NEXT that would allow me to USE each database, one at a time?
>
>TIA.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer