Sql 2005: Linking two databases together on the same server and having write permission on the second
I have a sql server 2005 database and only have readonly access.(DB A)
I want to be able to create a view and write reports. However I decided to create another database where I can create a view since I cannot do that in the readonly access(DB B)
How do I link the database (DB B) to database (DB A)? Is linked server the right tool? Also note that I will need to point a web application to this new database (DB B) meaning that I will need to have a connection string available to use in my asp.net code.