1

Setting "SET NOCOUNT ON" in a application always benefits the performance of the application. But how i can set it in my vb.net application in a better way. Is it possible to set it in connection string? Is there any best approach to do it? Setting it each time will be problem or there may be chance of missing it out.

IT researcher
  • 3,274
  • 17
  • 79
  • 143

1 Answers1

0

In SQL Server Management Studio right click on server node: Properties -> Connections -> Default connection options. Tick no count.

JohnyL
  • 6,894
  • 3
  • 22
  • 41