September 23, 2005 at 9:28 am
Is there a way to group stored procedures, triggers, functions, etc. in the new SQL Server 2005 Management Studio? For example, if you have a group of stored procedures that handle the order process in an e-commerce application, can these be grouped together in one folder, container, etc so that it can be found more easily or otherwise more accessible? It would be great to be able to do this. I know that there is a filter option to exclude various stored procedures, but I would like to be able to group objects by function.
Any feedback would be greatly appreciated!
September 26, 2005 at 8:00 am
This was removed by the editor as SPAM
October 4, 2005 at 6:31 am
Don't know if you can do this in SQL 2005, but you can do it in VS.Net if you create a Database project you can create any folder structure you wantto contain the scripts for the various objects.
October 4, 2005 at 2:40 pm
Only thing I can think of using the schema (took the place of owner) but that may not be what you want either. You could then click on the owner column in mngmt studio and it would be in order of schema.
Check out AdventureWorks DB that is installed with 2005 for an example of different schemas
October 4, 2005 at 4:05 pm
Thanks all. I think I will start using VS.NET to be able to group stored procedures by functionality.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply