Tag Info

New answers tagged

0

I have found the solution to my problem. My "server name" part of the sproc was being loaded from a column in the database which included the port number (because it is a named instance), therefore it read [Servername\Instance,Port].[database].... but when I removed the port it worked. Demonstration below. USE [master] GO CREATE DATABASE TestDatabase go ...


2

It's not supported, but you can get around it.. select * from openquery( LinkedServerName, 'exec [database].dbo.sproc @Id=@Id, @PItems=@PItems output'','' @PId bigint, @PItems xml output'', valueOf@PId, valueOf@PItems output' ) There ...


0

Okay, this is the reason :You should notice that the two individual queries with their distinct constants do get cached as adhoc queries. However, these are only considered shell queries and are only cached to make it easier to find the autoparameterized version of the query if the exact same query with the same constant is reused at a later time. These ...



Top 50 recent answers are included