Can't create folders in a SQL Server 2005 Management Studio project.
It would be handy to be able to separate scripts into folders. Unfortunately only three default folders are available: Connections, Queries and Miscellaneous
Workaround:
- Open the .ssmssqlproj file in a text editor
- Copy one of the LogicalFolder tags e.g. Miscellaneous
- Replace the Folder Name and Type. Make sure the Type value is different from all of the existing folders
- Your new folder(s) should now be available in SSMS
<Items />
</LogicalFolder>
3 comments:
I developed SSMS add-in which enables you to organize SQL objects not in SSMS project but directly in Object Explorer, it is helpful for me. Check it here http://www.sqltreeo.com.
This isn't quite working for me. I am able to create the new folders, but when I add files to them they just have the Folder Icon and throw an error when I double click on them: Value does not fall within the expected range.
Thoughts?
Sorry, never experienced that problem...
Post a Comment