Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 File Location Save As

Author  Topic 

spelts
Starting Member

14 Posts

Posted - 2006-09-04 : 08:50:12
by default the query analyzer saves file to c:\documents and settings..... can that be changed?

i cannot find anywhere to set default location. I am referring to the SQL code not the output

thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-09-04 : 08:52:49
Very strange. In my QA, I can select Tools menu and the Options menu.
In the Query File Directory text box in the General tab, I can change the location for my SQL scripts.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2006-09-04 : 09:28:04
Just another possibility:
=========================

If the directory to which it was pointing earlier is renamed or deleted, it will again point back to your Desktop folder. Please check whether this is the case with you, otherwise Peso's advice should work for you.

Harsh Athalye
India.
"Nothing is Impossible"
Go to Top of Page

spelts
Starting Member

14 Posts

Posted - 2006-09-04 : 10:25:20
all i can say is stupid me!!! i don't know why i didn't see that

thanks
Go to Top of Page
   

- Advertisement -