Post reply

Query from

  • September 21, 2007 at 4:41 am

    #374560

    Query from different servers

    Can someone tell me why this query works when I run it from one server, but not another (it returns nothing)

    select top 100 *

    from [ISLCLAPP].[JSek].[dbo].[ISLJSEKJournal]

    where Processdte = convert(varchar(8), getdate(), 112)

    Do it have something to Does with the linked server?

  • September 21, 2007 at 4:54 am

    #735171

    R u trying to connect to different server. if yes then first you have to link that server using " sp_addlinkedserver "

  • September 21, 2007 at 6:01 am

    #735184

    Thanks, my problem was that the linked server on the two server had the same name, but was pointing to different servers.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply