thanks, i got my answer..
even after opening a new window, i got the result as 1,1 and i was wondering why ???
stewartc-708166 (1/28/2010)
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...