[dba-SQLServer] SQL Server 2005 - Getting back the records affected

Stuart McLachlan stuart at lexacorp.com.pg
Wed Aug 5 22:16:51 CDT 2009


If you are using a query in Management Studio, it will tell you.  If you are using a stored 
procedure include the line "SET NOCOUNT OFF"

-- 
Stuart

On 5 Aug 2009 at 22:46, jwcolby wrote:

> In SQL Server 2005 when I perform an action query (Update, delete etc) how do I determine how many 
> records were affected?  Google is not being my friend on this one.
> 
> -- 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 





More information about the dba-SQLServer mailing list