Home Forums SQL Server 7,2000 General Synonym for Qualified name specification of Table([LinkedName].[databasename].[username].[tablename]) RE: Synonym for Qualified name specification of Table([LinkedName].[databasename].[username].[tablename])

  • January 23, 2004 at 10:20 am

    #491423

    Not completely sure what you mean, but you can create a view

    create view myview as select * from servera.ownerb.tablec

     

    and then select from this view.

     

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com