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 |
|
samtoffa
Yak Posting Veteran
60 Posts |
 Posted - 2004-07-26 : 07:01:06
|
| Are there any tools for managing and archiving stored procs, UDFs and UDDTs? Like all programmers, I always remember to write comprehensive headers in all my code ;-) but this just isn’t enough. I often want to use some of my nifty stored procedures and functions in various databases for different clients. Is there a management tool that will allow me to keep track of all my procedures and import specific SPs and UDFs into the required database? …and before anyone suggests that I just need to use clever descriptive names for my procedures I apologise for my lack of imagination! Hundreds of useful code blocks are generated on this site each week and it would be great to archive them in a usable way. Anyone at SQLTeam thought of an online repository? Am I the only one who thinks this could be a good idea?Sam |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-26 : 08:58:41
|
| I store all my SProcs in files on a development server - using both thoughtful names and thoughtful folder structures; and copious use of Windows Explorer Search :)But a repository is also a good idea ... but then you've got to write a front end to access it, which is why I choose Windows Explorer Search as my front end!Kristen |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-07-26 : 09:02:52
|
| Sam,Sounds like a data dictionary for code....Do you use change control tools like PVCS or source safe?AND....sounds a lot like...dare I speak it.....specs.....Brett8-) |
|
|
|
samtoffa
Yak Posting Veteran
60 Posts |
Posted - 2004-07-26 : 09:36:48
|
| Yes Brett, I used source safe many moons ago with visual basic. Sometimes you don't want all the complexities, particularly specs and 'documentation' when you just want to do a quick test of an idea. Kristen is right, a search facility like explorer is probably enough to do the job. However, MS did a fine job with the MS Excel function insert tool. When you go to insert a function in a spreadsheet it asks you for the category (Math & Trig, Financial, Text), then gives you a drop down list of available functions. I'm sure someone (maybe me) could make a similar add-in for Enterprise Manager. Perhaps a project for one of my MSc students...Sam |
|
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2004-07-26 : 09:46:33
|
| SQL Query Analyzer has something similar to that, the Common objects (including functions) listed in the Object Browser are picked up from an XML file. Take a look at it, it should be at the following location for a typical install: C:\Program Files\Microsoft SQL Server\80\Tools\objmgr80.xmlOS |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2004-07-26 : 09:56:46
|
Crikey Mother Reilly! I could have done with knowing about that years ago  I presume I can just throw all my stuff into the XML file and away I go ...Kristen |
|
|
|
samtoffa
Yak Posting Veteran
60 Posts |
Posted - 2004-07-26 : 10:03:36
|
| Yes, I came across the object browser a while back but I had no idea that the data was held in this xml file, well spotted! It doesn't offer the user the option of adding their own functions or have I missed something? Also, the REAL value would come with something that can handle stored procedures. |
|
|
|
|
|
|
|
|
Stored procedure and UDF management tools