I've just started to learn SQL 7. In VB with Access I used to create all SQL statements in VB code. And my last (not too big project) contains several hundreds of SQL statements. In SQL Server it's recommended to use stored procedures and call them from VB code. If in VB I can separate all statements putting them in different classes, forms, modules, then how can I keep track for all stored procedures in SQL Server. I do not see any subfolders, or the ability to create them in Stored Procedures node in Enterprise Manager. But I believe that big database can have thousands of stored procedures.
Sorry if my question is silly.
Vlad