ALTER PROCEDURE [dbo].[GetLogShippingStatus]

WITH

EXECUTE AS CALLER

AS

DECLARE @pErr varchar(256);

DECLARE @pErrVal int;

DECLARE @pTargetDate datetime2;

BEGIN TRY

INSERT INTO dbo.LogShippingStatus

SELECT

primary_server,

primary_database,

backup_threshold,

...

Tried all of the following:

ProdB

ProdB,1433

ProdB.my.dom

ProdB.my.dom,1433

AliasToProdB

AliasToProdB,1433

AliasToProdB.my.dom

AliasToProdB.my.dom,1433

Nothing works. Keep in mind, as I stated in my OP, all this works fine if I am logged into the DevC server (RDS or physically),...

Thanks to @opc.three for all the input. If this is the case, it seems rather ridiculous that all the ducks must be in a perfect row for this to work....

Did that. Even ran setspn with the -X option and no duplicates exist for any of the affected servers or accounts. I'm not quite sure what you mean by "perfect"....

The double hop issue is the direction I am leaning as well. But, all instances are using the same domain account to run their services, and all three servers are...

Index fragmentation is 85% on 7 tables.

Indexes are rebuilt weekly.

Me'thinks that the whooshing sound you hear is the heads of some people flying about in the clouds with nothing serious to think about. Me also thinks that, while Sean...

This article is really a joke, isn't it? Is anybody really taking this guy seriously? He is obviously talking to the drunks out over the right field wall I guess....

Just out of curiosity, why does Sybase return 20?

This bears a frightening resemblence to the Microsoft Exams. Choose the answer that appears most obvious, and, "buzz...., your wrong!"