SQL Server Performance

to get the getdate() of another server. using linked server.

Discussion in 'General Developer Questions' started by dhamu294, Feb 2, 2010.

  1. dhamu294 New Member

    If we have a sqlserver in two different geogriphycal region and if it is connected both the server to linked server. Eg. India and US. if we connect india server to US through linked server. how to get the getdate() of US servers.
  2. Elisabeth Redei New Member

    May I ask what you get back currently and could you also send the query you are issuing?
    I would imagine (but can't try at the moment) that if you issue:
    SELECT *
    FROM OPENQUERY(USLinkedServer, 'SELECT getdate())
    ... you should get the date of USLinkedServer.
    Kind Regards,
  3. dhamu294 New Member

    Thank you Elisabeth.
    This date statement was striking in mind for a long time. I to dont have an requirement or work environmnet to to test it.

Share This Page