Hi Sergey,

Virus ???

No, i have various sp metadata interpreters,
that read the metadata tables,
and build the structure of the application databases
( tables,views,checks
and of course triggers, sp and udf ).

This assembly the sp application code ( automatically ) and have to
CREATE it into the database.

Fabio

>Hi Fabio,
>
>Are you trying to build kind of "virus" Sp that reads itself and than creates a copy in the specified database and owner? Or it's something else? Can you clarify?
>
>>I have to written a rootdb.dbo.SP
>>for to create a cDbName.cUser.SP into a cDbName Database name.
>>
>>Of course cDbName and cUser are input parameters for rootdb.dbo.SP.
>>
>>I have found a one twisted solution.
>>
>>Someone known a simple solution ?
>>