Are there any SQL Profiler's in Pervasive SQL 2000 or v8? I'd love to see a profiler like MS SQL2000 has.

You can use the Query Plan Viewer. I don't know how it compares to Profiler but it does give the query plan used by the Pervasive engine and shows whether (and which) indexes were used. For more information see: http://www.sys-con.com/tango/archive...ary/index.html

Thanks for the reply but I was looking for something else. MS SQL's PROFILER is used to see which SQL cluases are going on on the server. With the profiler I can see which SELECTs is my program running, when it run them, how long did they run etc..

In that case, you might look at http://www.pervasive.com/ComponentZo...+%2F+Utilities which is a tool from Pervasive's web site that times queries.