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

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.

Thanks bill It is thereMuhammad Mehdi