Getting Date Time for Linked Server

  • I am accessing a linked server to synchronise some data.  To ensure data consistency I need to know that the linked server has a valid (synchronised) date and time.  Can anyone please tell me how to get the current DateTime on the remote linked server?

    Thanks

  • Use OPENQUERY

     

    SELECT * FROM OPENQUERY (LINKEDSERVERNAME,'SELECT GETDATE() AS CUR_DATE')

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

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