?
Solved

Add folders to the Solution Explorer

Posted on 2008-10-30
2
Medium Priority
?
606 Views
Last Modified: 2012-06-27
I tried very hard to use the Solution Explorer functionality in SQL 2005 but quit as soon as I saw that it didn't alphabetize scripts.

After a long wait we have SQL 2008 and I'm again trying to use the Solution functionality. I have a solution and a project and it does correctly alphabetize scripts.

The project that I'm trying to use has about 500 scripts and I have them in folders by catetory - reports, utilities, triggers, db specific, etc. I don't see any way to add folders to a project/solution like you can in Visual Studio. Am I missing anthing? Do I have to wait 3 more years?

To restate: I need a project with 500 scripts, and the scripts need to be in folders (and subfolders)
0
Comment
Question by:sgray128
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 17

Accepted Solution

by:
HoggZilla earned 750 total points
ID: 22853145
This is a very frustrating "feature". I use the Template Explorer to store scripts and subfolders.
0
 
LVL 2

Author Closing Comment

by:sgray128
ID: 31511703
Points for answering - Microsoft, are you listening?
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question