This is a very minor annoyance of mine; maybe someone can help!
I often build and modify databases from within Visual Studio 2010 Pro. I have VS set to prompt me after every change to save a change script, so that I have the scripting necessary to update the production DB when the time comes.
My issue with this is that the default directory for saving these files is always the 'current directory' when Visual Studio was started. That means it was originally the VS install directory, until I changed my shortcut to VS to at least pass my Visual Studio projects root directory.
But as a freelance developer working on various projects for various clients, my folder structure from there is still somewhat significant, so it's usually more than just a single folder down from there I need to go.
One solution can be to open Solutions from their Solution files directly, since that passes the solution directory as current. However, I never do this; I start VS directly and typically load recent projects from the start page.
So, does anyone know a way to change the default location that VS will offer to save database change scripts? It's not in the standard settings of VS; I imagine an add-in/extension could do something there, but I'm not aware of any which do, and I've not had enough experience working on extensions to have an idea how to do one myself.
Any help finding/creating an appropriate extension, or other hack, will be appreciated!
p.s. I really don't want to earn a Tumbleweed badge off this question! heh