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.