Hi Ahmed,

When a new database is created for the new client, this stored procedure can be altered.

As dynamic sql is not precomplied, I think conditional execution is faster.

However, I have not compared the performance of these 2 types of stored procedures.

Thanks.

Suresh