.dqy extension files
I have filename.dqy files
XLODBC
1
DSN=Envisage;UID=User ;APP=Microsoft Office 2003;WSID=PC-A;DATABASE=Envisage;Trusted_Connection=Yes
exec Rpt_sv_envisage1 '01-July-2011 00:00:00', '30-Aug-2011 23:59:59', 'CustomerA'
Since our database guy left here is the command I normally run which generates reports within given parameters…
XLODBC
1
DSN=Envisage;UID=User ;APP=Microsoft Office 2003;WSID=PC-A;DATABASE=Envisage;Trusted_Connection=Yes
exec Rpt_sv_envisage1 '01-July-2011 00:00:00', '30-Aug-2011 23:59:59', 'CustomerA'
In the whole command “exec Rpt_sv_envisage1” I could not find this Rept_SV_envisage1 in the database. Can someone please give me guidance where is this
located into database?
Muhammad Mehdi
August 31st, 2011 6:43pm
Hi Muhammad
Mehdi NZ,
Thanks for your post.
Rpt_sv_envisage1 is a stored procedure, you can go directly to the database Envisage, and then expand the Stored Procedures
node, to verify whether exists the relevant procedure.
More information about
Database Query (.dqy) File Format, please refer to the link below:
http://support.microsoft.com/kb/164729#
Thanks,
Bill LU
Please remember to mark the replies as answers if they help and unmark them if they provide no help.If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.
Free Windows Admin Tool Kit Click here and download it now
September 2nd, 2011 7:00am
Thanks bill It is thereMuhammad Mehdi
September 4th, 2011 4:53pm