>>>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.
>>
>>Check sp_MSForEachDB SP.
>>You can ONLY Goolge the name, it is Undocumented.
>
>Thank you. Do I understand correctly (from just scanning a found article) that I have to create a stored procedure and then the SP you mention will execute it against each database?
No, you can use it directly.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
