Browse by Tags

Sorry, but there are no more tags available to filter with.
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: ,

This Blog

SQL Blogs

Syndication