• when a new query window is opened, a connection is made to the database, which returns a result (not visible)

    this item is reflected in the @@rowcount as 1

    however, SET NOCOUNT ON does reset this to 0.

    interesting question, I think this is going to be another interesting discussion...

    ____________________________________________
    Space, the final frontier? not any more...
    All limits henceforth are self-imposed.
    “libera tute vulgaris ex”