This is known as the 'Double-Hop Problem' and there's a lot of information out there.  It essentially boils down using Kerberos to pass the client's credentials from one server to...

DECLARE
    @TimeTo DATETIME = '2018-07-15 10:11:12'
    ,@TimeFrom DATETIME = '2018-04-01 09:03:27';

SELECT
    CAST(DATEPART(YEAR,startM) AS CHAR(4))
    +'-' + CASE
                WHEN DATEPART(Month,startM) <10
                    THEN...

It's a funny old world; I noticed that somebody had 'liked' this post I made four years ago, almost to the day.  When I made it there was a lot...

I've just had a conversation with our client about the fact that backups weren't being taken on the instance that we provide to them.  It's not strictly our problem, that's...

Hey Eirikur, could I pick your brains about something please?

My wife's leading school trip* to Reykjavik at the beginning of February and she hates[/u] being cold.  From what...

It's Croatia for us.  We absolutely love the place and I think I'm genetically pre-disposed not to support France.