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 ...


1

CAP theorem: specifies that a distributed system can provide two services (ex. Availability and Partition tolerance) but never three. If for example, a service provides Availability and Partitioning it can never ensure Consistency, not immediately, thus Eventual Consistency is used, which allows the infrastructure to flux between inconsistency and ...



Top 50 recent answers are included