Post reply

Solutions, Projects, and Save AS

  • March 20, 2007 at 1:02 pm

    #172833

    I'm pretty new to SQL Server 2005, and the SS Management Studio. So the following questions may just be revealing my ignorance. If you can help correct my ignorance, I'd appreciate it.

    Using SSMS, with no version control software, I have been trying to use the Solution explorer ('cause I'm assuming that is what the big kids do).

    But I trip over...

    1.The default solution seems to be in My Documents, which is not where I want it.  Is there a way to change the default?

    2. To add a new query to a project I seem to need to create a new (empty) query in the project, then copy my actual SQL from some other source, and then paste it into the new query?

    3. When I do a "Save As..." the name of the original query is changed, the name on the SSMS tab is not changed, and no new copy of the query is saved (anywhere).  I have never seen any other application (including and since the 128K Mac) with this non-standard behavior.

    4. Why is it considered progress to restrict the directory structure in a project to a single level? (OK, that was a limit of the first 128K Mac file system, but jeeze!)

  • March 23, 2007 at 8:48 am

    #696632

    1) Visual Studio 2005 Apps create a directory under current user's My Documents folder. OS standard. You have the option when creating the Project, in any VS App, to change the dir. I have not seen any other place to override the OS default. May be they will with the new release, whenerver.

    2) If you rigth-click, in Solution Explorer, on top of the Solution's name select Add, Existent Item. This way you bring your queries in from any place. It does not mean you need to move the file fisically into the same directory wher the solution exists.

    3) I have no idea

    4) Well, in SSMS you really don't have too many objects options, just connections and queries. Everything else can be SP or UDF which are stored in the DB.

    Changes are good, and criticism is always constructive.

  • March 23, 2007 at 9:02 am

    #696636

    Thanks for your post!

    Are you registered? I was unable to send you a private message.

    (Just wanted to note that you had typed "fisically" when you probably meant "physically". It's just a nit...)

  • March 28, 2007 at 7:29 am

    #697383

    you can change the default location for all the VS stuff; it is stored under the registry under the following key(s): Visual Studio 2003 is 7.1, and 2005 has a parallel key there as well.

    HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\7.1

    get ready for a copy and paste job there because the following keys have something like this in them, and maybe you want it to always go to another location

    "DefaultNewProjItemLocation"="C:\\Documents and Settings\\YOURUSERNAME\\My Documents\\Visual Studio Projects"

    becomes

    "DefaultNewProjItemLocation"="D:\\vsProjects"

    C:\vsProjects\ instead:

    keys to change:

    "VisualStudioProjectsLocation"

    "DefaultNewProjectLocation"

    "DefaultOpenProjectLocation"

    "DefaultOpenSolutionLocation"

    "DefaultNewProjItemLocation"

    "DefaultOpenProjItemLocation"

    "DefaultFileOpenLocation"

    "DefaultBrowseComponentLocation"

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 28, 2007 at 7:58 am

    #697403

    Thanks for the registry key information!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply