Does anyone know if there is a tool like MS SQL Server's Profiler that will allow me to monitor the SQL statements being issued against a Pervasive database? I have both 2000i and 8 of Pervasive if there is a tool with either of those versions. Basically, I want to see what tables and fields...
Is it possible in SQL Server 2000 to create an index on a table declared as a variable. I get a syntax error when attempting to do this.
For example...
DECLARE @mytable TABLE (col_a INT)
CREATE INDEX i_mytable ON @mytable (col_a)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.