-
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!
-
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
-
Forum Rules
|
|