cross database query sql server where databases are password protected
cross database query(insert & update) in sql server where databases are password protected
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
you can always query another database in the same server by
db_name..table_name
as long as the user have read permission on the table,
if you need to update/delete, you need to grant corresponding permission to the user
db_name..table_name
as long as the user have read permission on the table,
if you need to update/delete, you need to grant corresponding permission to the user
>>cross database query sql server <<
I suspect you mean Cross-Database Ownership Chaining
>>where databases are password protected<<
No such animal in SQL Server. Perhaps you mean MS Access?
I suspect you mean Cross-Database Ownership Chaining
>>where databases are password protected<<
No such animal in SQL Server. Perhaps you mean MS Access?
ASKER
this solved the problem at some extent.
http://www.mssqltips.com/tip.asp?tip=1782
http://forums.asp.net/p/820591/821922.aspx
http://www.dbforums.com/oracle/977676-cross-database-query.html
Thanks
Guvera