Great, this works fine!

Adi, thank you very much!

Wow! Exactly what I had in mind!

It's very nice looking. I will adopt this construction, for sure!

EvilPostIT you helped me great with this! Thanks a lot!

I would like to execute the result of the following SQL in a job:

select

'alter database ' + sd.name + ' modify file (name=N''' + sm.name+''', filegrowth = 100MB)'

from sys.master_files...

Yes, the globals give you page numbers, userid and so on but no server\instance name!

The idea is to execute it on linked servers to gather space usage information and store the collected info in one centralised table.... so it would be a nice solution...

Hi John,

Thank you for your reaction.

You're still using the insert into ---- exec construction. If I use this in my stored procedure, the procedure can be executed with succes. But...

Hi Ryan,

Example 1 - create the same table in multiple databases

For dbName in database1, database2, database3

do

use $dbName

go

create table test .......

done

Example 2 - delete records in multiple tables (the column update_date...

Hi Ryan,

Thanks for your quick reaction.

It will do the job, but it is not wat I was looking for.

I want to use a construction in which the user needs...