June 29, 2007 at 10:03 am
Hi all,
Just starting out with sql server 2005.
When I used to use Query Analyser I had tons of saves .sql (queries) in a series of folders on the network which I frequently returned to. I set this path up in Query Analyser and frequently opened them as required jobs needed doing.
To accomplish the same routine, do I need use Solutions/Projects?
Am I thinking this through correctly.
Secondly, Is there a way to change the default open/save folder for Projects as currently it saves to User/SQL Server Management Studio/Projects, on C: drive.
Many thanks and hope all is clear
Scott
July 2, 2007 at 6:23 am
It should be available in tools->options menu.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com
July 4, 2007 at 12:18 am
You can go to the following path in registry to change the directories.
Type regedit.exe in Run and press enter
Expand to:
HKEY_CURRENT_USERS\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell
In the right pane, you will have the option to change Default location for projects, projectitem, open project , solutions etc. You can change whatever is necessary.
NOTE: Take a backup of registry before editing it and change everything correctly and dont change any system Keys or strings.
Regards..Vidhya Sagar
SQL-Articles
July 4, 2007 at 2:06 am
many thanks. thats a great help
Scott
July 5, 2007 at 2:43 am
hi
thanks for that
"Keep Trying"
July 6, 2007 at 5:38 am
I would suggest you get used to using projects and solutions and VSS. It will take some getting used to if you have only been doing database administration, but it it much better than a directory full of script files.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply