Yes - use SQL profiler


Stuart

>>> "Hornak Wayne "
<mssqldba-ezmlmshield-x75698054.[Email address protected] 04/28/05 1:52
pm >>>

Can you capture the SQL statement that are passed to SQL Server 2K?

I am using Crystal Reports 10 having the reports hooked to a SQL Server
2K
view. Utilizing the functionality of CR by modifying the call to the
view.
What I want to do is see exactly what it is that SQL Server is
receiving.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




*************************************************************************************
The contents of this email are confidential to the intended recipient.
It may not be disclosed to or used by anyone other than the addressee,
nor may it be copied in any way. If received in error, please contact
the company on 01234-791388, then delete it from your system. Please note
neither the company nor the sender accepts any responsibility for viruses
and it is your responsibility to scan attachments (if any) for viruses.
No contract may be concluded on behalf of the company by means of email
communications.
*************************************************************************************


MS Sql Server LazyDBA home page