Once again thank you David, even when you're a little bit late you still of great help, I was just trying imbricate sql and...

Hi every body this is the real example: any help is more than welcome:

this is the calling procedure:

ALTER      PROCEDURE PS_Migration_DBMED_PABI_2 @DbnameSource  _label, @DbNameDestination _label

AS

SET...

any solution? this is critical to my program because i'm calling this function from an other stored proc that is also using dynamic sql;...

Thank you VM David, it works!

My SPs will run on many database, and i don't want to  keep the name of the database hard coded in any one of my SP so each time i'll...

thank you vm,

the process of migration I'm working on must run as one piece(one call for the whole process).

I've tried DTS but it's not what I really need, it do the work...

Hi, if i have to use any of the system SP  in my SPs  without having them in my DB (from the mastr DB), do i risk to have any problem...

Thank you Frank, in fact there is no SP in my model DB, is exporting them from an existing DB to the mode lDB?

Hi,

Thank you for your help, I'm sorry, I'll bother you just one more time

but can you explain the use of  '26' in this instruction

insert #b(s) exec ('dbcc outputbuffer(26)')

Cheers