Hi,

Can you run SQL Trace from within VFP using SQLPT?

thanks,

Paul


>>I need to know whether or not a SQL connection that is opened by a remote view is closed when the view is closed.
>>
>>Also, is there any way to monitor connections to the SQL Server?
>
>Monitoring connections is easy. For SQL Server 6.5 you can use the SQL Trace tool. For 7.0, MS renamed the Trace tool to Profiler. Both tools will allow you to capture various information including when connections are created and what queries are submitted to the server over the connection.
>
>It was my understanding that a connection that was created by a remote view would be closed when the view was released. If the view was configured to share a connection with other views, the connection will probably be closed when all the views are released.