[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.sqlserver.programming

using template directory switch when calling ISQLW from cmd line

Eric Bragas

3/28/2007 11:37:00 PM

Hi Everybody,

I am trying to use the "-T" switch when calling Query Analyzer from
the command line, but it's not working the way I expect it to. For
example, the following statement works just fine:

isqlw -Smyservername -dmydbname -E

But this statement does not:

isqlw -Smyservername -dmydbname -E -T"c:\mytemplates"


What I expect is for the Query Analyzer Templates tab to default to c:
\mytemplates, but it does not. It always defaults to the folder that
is specified in Tools...Options...Template File Directory.

The reason I want this to work is because I have 100+ *.tql templates
and it's getting difficult to find the right template when I need it.
If I had them organized into folders, they would be easier to find.
Unfortunately, QA doesn't seem to display more than two levels of
folders in the Templates tab.

If I am misunderstanding the -T switch, please set me straight. If
I'm wrong about the 2-level folder limit in QA's Templates tab, please
correct me on that. If you think you have a better way of doing what
I'm trying to accomplish--that is, organize my mess--please advise.
Otherwise, I need somebody to tell me what I'm doing wrong with this -
T switch.

Thanks,
Eric