[dba-SQLServer] Tell Query analyzer where to store queries

John and Mark:

For SQL 2000 at least
In Query Analyzer:
Tools -> Options -> General->Query File Directory

That should do what you want. You can also save different configurations if
you want to get fancy.

James Barash
 

-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Mark A
Matte
Sent: Friday, November 03, 2006 1:23 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [dba-SQLServer] Tell Query analyzer where to store queries

John,

I am using an older version(SQL7)...and the only thing I've found with query

analyzer is 'open' or 'save as' always goes to the last folder I saved in.  
I couldn't find any setting to pick a specific folder.  If you figure it 
out...please share.

Thanks,

Mark A. Matte

>From: "JWColby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer] Tell Query analyzer where to store queries
>Date: Fri, 3 Nov 2006 11:15:27 -0500
>
>Is there any way to tell query analyzer where to save queries I am 
>building,
>preferably on a database level?  It is just "offering" to save them in my
>documents.  Not useful to have to navigate over to another drive / 
>directory
>structure every time I want to save a query.  Also not helpful to have a
>thousand queries all stuffed in my documents.
>
>John W. Colby
>Colby Consulting
>www.ColbyConsulting.com
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Try Search Survival Kits: Fix up your home and better handle your cash with 
Live Search! 
http://imagine-windowslive.com/search/kits/default.aspx?kit=improve&locale=e
n-US&source=hmtagline

_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com