mercredi 7 septembre 2016

How to copy stored procedure from one database to another database on same server dynamically

I tried like this:

SELECT @def = [definition] 
FROM [@from_db].sys.sql_modules 
WHERE object_id = OBJECT_ID('MyProcedure') 

EXEC(@def); 

or any other way same like this.

Aucun commentaire:

Enregistrer un commentaire