Microsoft SQL Server Statistics via ODBC

Question

I have an instance of SQL Server that I am trying to verify. In SQL Studio, I can enter

SET STATISTICS TIME ON

and then view the statistics displayed. From C ++ code, I can do something like

SQLExecDirect(hstmt, "SET STATISTICS TIME ON", SQL_NTS);

and then get this statistics through SQLError.

Is there a way to get these statistics when accessing SQL Server over vanilla ODBC. In this case, I use the Ruby connector DBI:ODBC, which works great to connect and run queries, but I could not understand this metafile.

Answer 1

, odbc, Sql Server, Sql Profiler ? , , sprocs Sql Server.

Answer 2

dbh.func(:stat)