Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Bex
Aged Yak Warrior
580 Posts |
 Posted - 2008-04-18 : 04:28:52
|
| Hi Is there a way to select out the contents of sys.comments for an object (in this case, a procedure) so that it is nicely formatted?The reason being, is that I want to update source control with all objects from the live environment (as it has become out of date.... long story). Currently, we have a single script for each object, split in directories for each object type. Anyway, I also want to wrap the objects in our standards (check for object existence, print out success/fail statements, etc). Any suggestions to make the process more automated and less painfull? I don't want to have to script each object out, manually wrap it in standards and save as that would be perhaps the most tedious task in the world!!!!Thanks!Hearty head pats |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-18 : 04:33:37
|
| Check this:-http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=99053 |
 |
|
|
Bex
Aged Yak Warrior
580 Posts |
Posted - 2008-04-18 : 05:24:20
|
Thankyou!!  Hearty head pats |
|
|
|
|
|
|
Selecting procedure structure from sys tables