Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Create folders under a project using Visual Studio aka BIDS

Using BIDS any user cannot create folders under the project like VS2005 does. As usual user can create more than one query folder, and the root folder can create child folders. The only way to recover this problem is to edit the XML file that is created on the project:

Edit the .ssmssqlproj using notepad or some sort of text editor
Copy one of the existing file folder elements, give it the name you want and a unique type.
    <LogicalFolder Name="Miscellaneous" Type="3">
     <Items />
    </LogicalFolder>

-- copied to --
    <LogicalFolder Name="Miscellaneous2" Type="4">
     <Items />
    </LogicalFolder>

Save the edited text.
Open the solution

This should get a new folder on the project and also ensure to check by refreshing under BIDS.

 

Posted: Sunday, April 15, 2007 11:00 AM by SQL Master

Comments

No Comments

Anonymous comments are disabled