JWColby
jwcolby at colbyconsulting.com
Fri Nov 3 13:38:10 CST 2006
James, You da man! John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of James Barash Sent: Friday, November 03, 2006 2:18 PM To: dba-sqlserver at databaseadvisors.com Subject: Re: [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 _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com