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 |
|
tuka
Starting Member
26 Posts |
 Posted - 2009-09-18 : 06:44:12
|
| Hi, I have to periodically do fixes to application databases deployed on various sites. I would like to move the deployed sprocs into a version control system and so have to do bulk downloads of the sprocs. Is there a way to from a T-SQL statement generate all the content of a particular sproc ?Thanks in advance. |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2009-09-18 : 08:02:33
|
| The version/source control system will allow you to tag the code when you check-in. And then it allows to to extract the code when you're ready for a release.You can use sp_helptext to get the contents of a procedure. Or use the Generate Scripts option in SSMS. |
 |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2009-09-18 : 18:59:13
|
| There are third party products that will perform comparisons of the schema and objects on different servers and produce the necessary scripts to bring them (or a subset of objects) into sync. since i have absolutely no connection with their company, I can recommend thew RedGate Compare product as one that I have used and enjoyed.Perhaps someone else can recommend another similar product.=======================================Men build too many walls and not enough bridges. -Isaac Newton, philosopher and mathematician (1642-1727) |
|
|
|
tuka
Starting Member
26 Posts |
Posted - 2009-09-21 : 11:07:24
|
| sp_help is what I was looking for... I could use it in some scripts also the compare tool - I used the schema compare tool that comes with VS Team System which worked for some quick analysis but I will be looking into a more automated process.Thanks a lot for the input.Tuka |
|
|
|
|
|
|
Downlaod stored proc in remote server