Specify the default extension for results files

  • I seek to (permanently) change the default file extension for "results to file" from .rpt to .csv.

    This was possible in SQLServer 2000 but I can't find it in 2008.

    I can change the DESTINATION (path) but apparently not the default FILE EXTENSION.

    Thoughts welcome.

    Thanks!

    Ron


    BOL for 2000:

    http://msdn.microsoft.com/en-us/library/aa216935(SQL.80).aspx

    SQL Query Analyzer Help (SQL Server 2000)

    General Tab, Options Dialog Box

    Use the General tab on the Options dialog box to specify file locations, file extensions, and other configuration settings.

    Options

    Results file extension

    Specify the default extension for results files


    BOL for 2008:

    http://msdn.microsoft.com/en-us/library/ms189368(SQL.100).aspx

    SQL Server 2008 Books Online (May 2008)

    Options (Query Results/SQL Server/General Page)

    [This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

    Use this page to determine the default behavior of the query Results pane. To display these settings, on the Tools menu, click Options, expand the Query Results folder, select SQL Server, and then click General. Changes to these options are applied only to new Microsoft SQL Server queries. To change the options for the current queries, click Query Options on the Query menu or, in a SQL Server query window, right-click and select Query Options.

    Default destination for results

    Sets the default destination for result sets to either text or a grid in the Results pane, or to a file.

    Default location for saving query results

    Sets the default location where result pages are saved. Unless changed, the default location is the user's My Documents folder.

  • Don't see a way to do it. I'll forward along.

    Steve

  • File extension for 'Save Result as ' dump seems to be no longer configurable, as even registry entry storing the configuration value has been removed.

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\80\Tools\SQL Query Analyzer

    ExtnSave:=.rpt

    To be honest, it may be still configurable, but you would have to hack this registry node:

    HKEY_CURRENT_USER\Software\Microsoft\Microsoft SQL Server\90\Tools\Shell\Open Find\Microsoft SQL Server Management Studio\Settings\Save Grid Results :alien:

    Cheers, Max

    Check-out free open-source utility Sql Server Replication Explorer[/url]
  • Thanks for the insight. It's not important enough for me to mess with the registry 🙂

    Thanks again,

    Ron

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

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