Friday, March 9, 2012

Dose sp_helptext loss something?

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