I am using sp_helptext to generate script of stored procedure. However someone said sp_helptext loss something if stored procedure is big. That means the script is not completed. Is it true?
Thanks
ZYTJust curious, why not use Enterprise Manager to right-click on the stored procedure, then go to All Tasks -> Generate SQL Script...?
Then you can punch the "preview" button and then the "copy" button to get the script onto your clipboard.|||Thanks for reply.
Because I need to create script from stored procedure.|||If you need to create a script from the stored procedure, why not use Enterprise Manager to right-click on the stored procedure, then go to All Tasks -> Generate SQL Script...?
Then you can punch the "preview" button and then the "copy" button to get the script onto your clipboard.|||sp_helptext only returns the first 4000 chars as i recall.|||Good Job, Jez...probably more constructive than a third post from me ;)|||check out this app I wrote if you want to generate scripts in an automated way:
http://www.codeplex.com/scriptdb
No comments:
Post a Comment