I just need to do this procedure one time only. I have many of my customers databases (copies) in my SQL Server. I made a change in the structure of one of the tables and want to update them all in one step. The same I need to do with one customer who has several of my application databases in their SQL server. Again, one time, one step.
>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.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham