dcsimg
Results 1 to 2 of 2

Thread: Link a view to another database

  1. #1
    Join Date
    Jul 2007
    Posts
    1

    Link a view to another database

    Hello,

    I have createf a view in a database, let's say DB1 and on the same server I have another database DB2( this are different databases). I need to be able to run the view created in DB1 from DB2. I have Microsoft SQL SERVER 2000. I know that synonyms will be the answer for my question, but my version doesn't allow this.

    Thank you!

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Run this in db2 if have select permission on the view in bd1:

    select * from db1.owner.view

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •