Organising Stored Procedures

Last Post 16 Jun 2006 05:47 AM by Miriam_SQL. 4 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Miriam_SQL
New Member
New Member

--
16 Jun 2006 01:13 AM
Hello everybody,

do you know if there is any way of organising SP's into folders?

Thanks in advance.
mwesch
New Member
New Member

--
16 Jun 2006 02:52 AM
If you use Visual Studio 2005 to create/manage your source code, then you can in the Solution/Project. But not a part of SQL Server in EM or QA.
Miriam_SQL
New Member
New Member

--
16 Jun 2006 05:47 AM
Thanks a lot.
nosepicker
New Member
New Member

--
16 Jun 2006 07:36 AM
Typical way of "organising" stored procedures is by naming conventions. Not always that pretty or practical though.
SQLUSA
New Member
New Member

--
21 Jul 2006 12:53 AM
True. Prefixing is a good way of organizing it. Visual Studio is a physical filing system does not help with the logical organization.

Also I prefer long meaningful names: glMonthlyRevenueReport - gl is the prefix for all general ledger related sprocs.

Kalman Toth, Database, Data Warehouse and BI Architect
http://www.sqlusa.com/order2005/
The Best SQL Server 2005 Training in the World


Acceptable Use Policy
---