Home Forums SQL Server 2008 SQL Server 2008 - General SET STATISTICS TIME ON RE: SET STATISTICS TIME ON

  • November 13, 2012 at 6:50 am

    #1558461

    ben.brugman (11/13/2012)

    How to save the results from "SET STATISTICS TIME ON" in table format?

    Ben Brugman

    In exactly same way as result of PRINT - it is impossible in T-SQL as it's does output into message

    stream.

    If you really desperate, you can create some client application (eg. in C#) which will execute your sql statements and save message stream into some table.

    _____________________________________________
    "The only true wisdom is in knowing you know nothing"
    "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
    (So many miracle inventions provided by MS to us...)

    How to post your question to get the best and quick help[/url]