Thanks for the link.

It's really what I want to do.

They had the same problem with dynamic sql.

To solve the issue, they :

- have created "real" tables (for exemple :...

I merged everything in one insert command into a temporary table.

But I am still stuck with dynamic sql because I need a variable as database name for sys.objects, sys.schemas, sys.indexes...

The...

You're right !

I will keep you informed (weekend starts now).

The goal is to create a repository database from where admin tasks could be executed.

The stored procedure should reorg/rebuild indexes of a database.

Dynanic sql worked but new problem with variable...

Thanks for the reply.

I didn't know this limit.

Let's use dynamic sql !