October 31, 2011 at 4:20 am
I want to Create Sub Folder under Stored Proceudre folder in SSMS. I want to categories my sps in differnt Folder. Is there any mechanism in the SQL Server to create new Folders like in Visual Studio.
Thanks
Azhar
October 31, 2011 at 8:18 am
No you can't create your own folder under stored procedures. This is where naming and schemas really come into play. With decent naming and schemas you can sort of organize them. The order will always be first by schema and then by name. It would be a nice feature to allow the user to organize stored procs better as the amount of them can be quite large.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 31, 2011 at 8:19 am
take a look here:
it may do what you are looking for
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:23 am
J Livingston SQL (10/31/2011)
take a look here:it may do what you are looking for
That looks pretty slick. Have you used it?
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
October 31, 2011 at 8:32 am
Sean Lange (10/31/2011)
J Livingston SQL (10/31/2011)
take a look here:it may do what you are looking for
That looks pretty slick. Have you used it?
use it on a dev machine... use different folders for sprocs/views etc based on specific developments I am working on....helps me to remember what I called them and what they were for
:hehe:
also drag and drop between folders is easy
no problems ...but havent got heavy useage
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:36 am
forgot to mention...seems its only 2008 R2 at the moment.
more info here http://www.sqltreeo.com/wp/dowload-free-ssms-add-in-to-create-own-folder-for-database-objects/
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day
October 31, 2011 at 8:55 am
That looks like a cool / useful tool.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 31, 2011 at 10:59 pm
Nice Tool.It works for me.
Thanks
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy