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)