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 |
|
andrewcw
Posting Yak Master
133 Posts |
 Posted - 2012-03-14 : 12:54:56
|
| What are some ideas to organize stored procedures. SQL Server Managment Studio appears to list all procedures in a single list - no folder organization. I have read somewhere that I can change the schema but from my use of finding the right stored procedure that's the same as placing any prefix on the name to indicate use. Thanks !andrewcw |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-14 : 15:49:08
|
| we make use version control tool like VSS for this. We create seperate folders for each project and for each object type and maintain files inside it with added advantage that it preserves the history------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
andrewcw
Posting Yak Master
133 Posts |
Posted - 2012-03-15 : 00:38:13
|
| Thanks visakh16 - If I picture this in my head correctly, the SP view on SQL Server Managment Studio still looks ugly, but it does not matter because your usual view for the SP is in the source control's folder. Did I understand this right ?? I do see the source control under options in TFS. Will try it.andrewcw |
|
|
|
andrewcw
Posting Yak Master
133 Posts |
Posted - 2012-03-15 : 01:09:46
|
| OK - found drivers for TFS but then just decided to try VSS as I have used it before. On SQL Server Management Studio - under file I can open VSS. I created a file, but how do I check in the stored procedure ? Is there a utube on this activity somewhere ? I looked at http://www.kevingao.net/sourcesafe/integrating-sourcesafe-vss-with-sql-server-2008.html but right click my project file I made does NOT bring up the SQL server add new items window shown in item 6. Another idea is SQL Server Management Studio asks me if I want to save the .SQL files, and I just say no. Should I say yes & use the Add file function of VSS ? I noticed I could create a folder & I could rename the SQL file with my sp Name & then I think I could use VSS to map to my local folder of the project & load the sp text there. Is this close to your proposal ??andrewcw |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-03-15 : 15:48:12
|
| yep..create working folders on your machine and map it to vss. put code files onto folders and go to VSS choose add option to add it to server repository------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
andrewcw
Posting Yak Master
133 Posts |
Posted - 2012-03-16 : 00:42:24
|
| HI AGAIN - I found this video on utube and although my server management says I have a VSS plugin & its active, I dont see anything like this: http://www.youtube.com/watch?v=_iArvhK2B54 My plug in simply launches VSS & no more. Do you have a plug in like the utube, that seems really helpful. Thanksandrewcw |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-16 : 04:40:46
|
| RedGate's SQLSourceControl.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
advise on stored procedure organization