set nocount on

[ysyang]

Hi

I'm create sample procedure at SSMS(SQL Server Management Studio)

Code: Select all

create procedure testout
AS
set nocount off
select top 100 * from dbo.DatabaseLog

and execute sp

Code: Select all

exec testout

Reult Tab print 13 records and Message Tab print "(13 rows affected)".

but when procedure is alter

Code: Select all

alter procedure testout
AS
set nocount on
select top 100 * from dbo.DatabaseLog

Message Tab is not print message

How can I distinguish between the two SDAC?

[Dimon]

SDAC doesn't allow to see the number of rows affected for statements inside a stored procedure.