SET NOCOUNT
-
How to do SET NOCOUNT ON at database level or at server level Thanks in advance
-
How to do SET NOCOUNT ON at database level or at server level Thanks in advance
There is no option to turn this on for a particular database on the server. You can turn this off for the whole server
Properties > Connections > No Count checkbox.When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
-
There is no option to turn this on for a particular database on the server. You can turn this off for the whole server
Properties > Connections > No Count checkbox.When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
Hi Even then rows effected i'm getting -1 in select statement . What i'm observing is that when i put SET NOCOUNT ON before sql statement even then it is returning -1. I guess it shud return 0 . I'm having sql server 2005 . Please help. Thanks