How to import & export stored procedure in sql query like Table data ?

Dear all,
How to import & export stored procedure in sql query like Table data ?
thanks,
harshad prajapati
Hi
You can script the stored procedures using SMO or in SSMS. You should use
version control keep the code in it, then you know that you are scripting a
particular release/revision.
You can also use SSIS to transfer objects (not only stored procedures).
John
"harshad" wrote:

> Dear all,
> How to import & export stored procedure in sql query like Table data ?
> thanks,
> harshad prajapati