Link to home
Start Free TrialLog in
Avatar of TED_UBB
TED_UBBFlag for United Kingdom of Great Britain and Northern Ireland

asked on

SQL Server 2005 database organisation possibility?

Hello
this may be an odd request but, I was wondering if there is a way to 'organise' databases within SQL server 2005 standard.

We've installed a few applications over the years and we get a large ugly unorganised list of databases under the DB header in SQL studio manager.

Is there a way to create sub folders, somewhat like in Windows Explorer to organise databases into?

for example, some programs install more than one database. Rather than 2 or more db's clogging up the view I'd like to create a folder under DB to store all these same application oriented db's. This will also help to to realise at a a glance what programs create how manay databases and so on which are 'logically grouped'.

Hope that makes sense.

thanks, regards
Avatar of PIERCGG
PIERCGG
Flag of United States of America image

At this time, I don't think there is a way to create "folders" under the Database folder in SSMS.  To do a bit of cleanup where I work.  We've started combining databases that are used by the same application.  We've found that we didn't have to have thing  broken out into so many dbs.
ASKER CERTIFIED SOLUTION
Avatar of TED_UBB
TED_UBB
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial