| Author: Gaurav Arora 23 Nov 2008 | Member Level: Diamond | Rating:  Points: 6 |
Hi Sivakumar,
Whenever you want a stored-proc in a table you need to create the proc.
If you really want to copy or want the same proc in your another table. You can do the same as :
1. First of all Open Query Analyzer
2. Get the entire definition of existing proc like:
sp_helptext <procname>
3. Change the database [it doesn't matter you use (use <dbname>) or dropdown dbname list]
4. Run the query analyzer by pressing Ctrl+E or F5
5. The existing proc will be added in your selected table.
Before performing above task(s) please remember following(s):
1. The schema will be the same of targetted table
2. If not 1 then modify the proc as per your new table
3. You can also do the all above by generating Script from Query analyzer.
Best of luck!
Thanks & regards,
Gaurav Arora
Thanks & regards,
Gaurav Arora - Sr. Editor
Me in My Own Style
|