Browse by Tags

Determining Nullability of a procedure parameter
24 July 09 06:50 PM | MartinBell | 1 comment(s)
In my posting about NOCOUNT and linked servers I provided a script to create the necessary shell procedures that enabled NOCOUNT to be set ON and avoiding the problems of ROWCOUNTs being returned by linked servers. One of the problems I encountered when creating the script was that there is no metadata held on whether the procedure parameter had a default...
Filed under: ,
NOCOUNT and linked servers
11 July 09 04:16 PM | MartinBell | 2 comment(s)
The other day I was looking at calling remote stored procedures on a linked server when I hit upon this problem or feature, depending on you point of view!!...
Filed under: ,
Best practices on setting NOCOUNT
11 July 09 04:15 PM | MartinBell | with no comments
Setting NOCOUNT ON in stored procedures can have performance benefits, but that is not the only reason to SET NOCOUNT....
Filed under: ,

This Blog

SQL Blogs