Link to home
Start Free TrialLog in
Avatar of Dabas
DabasFlag for Australia

asked on

.dtq files that are saved when editing a SQL statement from Server Explorer

I really like the power the .NET IDE provides for easily viewing SQL tables, views and stored procedures.
It is much easier to use than Enterprise Manager or SQL Analyzer!

But if I have made any changes inside the IDE and I want to run my program, I get prompted to save these changes in a file that has a .dtq extension.

My question is: How can I use those files to my benefit if I want to return to that same screen after reloading the IDE?
I know I can open it as text to retrieve the SQL statement, but there is quite a lot more information there than just the SQL statement.

Thanks

Dabas
ASKER CERTIFIED SOLUTION
Avatar of Bob Learned
Bob Learned
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dranizz
Dranizz

I really like the manager and Analyser better.
Avatar of Dabas

ASKER

Thanks Bob!
> How many times have you asked this question, without a response?
This is my third time. :-)

If it is a crime to ask the same deleted question over and over again, then crime definitely pays!
Not only did I get an answer to my question, but I learned that it is worth while to delve into Database Projects, and read the whole series in awprofessional!

Thanks so much!

Dranizz:
If by manager you mean Enterprise Manager, then I feel that its nearly the same. What I really dislike about EM is that when I double click on a table I get into design mode, when all I want is to view the data or to filter it.
Analyser is good, and I use it often too, but sometimes one just wants to start with a set of interjoining tables and a graphical interface makes it so much easier. Specially if you can do all of it from the .NET IDE, without the need of crossing to the other application.

Dabas