Home Forums SQL Server 2005 SQL Server 2005 General Discussion Can I programmatically clone a stored procedure in tsql script? RE: Can I programmatically clone a stored procedure in tsql script?
Sean Pearce
SSCoach
Points: 15999
More actions
January 13, 2014 at 7:56 am
#1679584
You must be manipulating the string at some point between getting the definition and executing the dynamic code otherwise the create statement will fail creating a proc with the same name.
Can you post the actual code that is giving you that error.
The SQL Guy @ blogspot[/url]
@SeanPearceSQL
About Me[/url]