Default Text when Opening Query Analyzer

by Nov 4, 2016

Hi there,

Does anyone know if it’s possible to modify the default script when opening a new Query Analyzer?  I’ve searched all over and can’t seem to find this functionality in ADS.  My colleagues have the functionality in Toad… I figured ADS would surely be able to beat down Toad.  🙂

For example, every time I open a Query Analyzer I would like the following to appear:

SET NOCOUNT ON

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

SELECT

FROM

WHERE

GROUP BY

Response

Niels Gron over 7 years ago
There is not specific feature that will set the content of the window at opening, but you can accomplish this by mounting a folder in your Server Registration and have a set of script files in the folder. Double click on a file and it will open your Query Window with that file and contents. See attached.

Mike Seim over 7 years ago
Works for me! What a great solution. I had previously been using the “File Tree” and the “Shortcut Toolbar” but indeed both were a tad frustrating since I had to select which server I wanted to connect to. “Mounted Scripts” works much better. I like it! Thank you.