Post reply

Remote Server Tables

  • December 25, 2013 at 8:30 am

    #396029

    Hi,

    How to retrieve remote server(using linked server) table details(created date, Modified date...)

    I'm using below query. But it doesn't having modified date.

    Select * from ABC.Adventworks.dbo.sysobjects

  • December 26, 2013 at 5:46 am

    #1675931

    the more updated views under the sys schema, instead of the old dbo.sys* views are recommended instead.

    the view below has both a create_date and modify_date that can help in your search for DDL changes.

    Select * from

    ABC.Adventworks.sys.objects

    balu.arunkumar (12/25/2013)

    Hi,

    How to retrieve remote server(using linked server) table details(created date, Modified date...)

    I'm using below query. But it doesn't having modified date.

    Select * from ABC.Adventworks.dbo.sysobjects

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • December 26, 2013 at 9:08 am

    #1675962

    Thank u so much...

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

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