Home Forums SQL Server 2005 SQL Server Newbies How to "set echo on" in SQL Server 2005 to see code along with results? RE: How to "set echo on" in SQL Server 2005 to see code along with results?

  • This request may be and old one but I have found a solution to the query.

    Go to Query -> Query Options

    Select Text in the Results tree on the Opened windows

    Tick Include the query in the Result set

    Press OK

    Select Query ->Results to You may choose either Results to Text or Results to file.

    You will see your query, data output and final statement how-many rows effected on the same view

    Regards , Shaamil.