• Dear all,

    SET NOCOUNT ON

    Does not reset the @@rowcount to 0.

    @@rowcount is zero when we execute the system Defaults like as shown

    set ansi_padding on

    select @@rowcount

    set nocount on

    select @@rowcount

    set ansi_nulls on

    select @@rowcount

    set ansi_warnings off .... so on

    for all system defaults like above when we set system defaults on/off @@rowcount will be displayed as zero.

    other wise by defalut @@rowcount is zero.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)