LiCann
asked on
Two databases two sign-ins
If I have a database on one server that I log in with windows authentification and have tables on another server where I have a secured log on and password, my question is will I be able to use the tables from the secured database in a stored procedure in the unsecured database?
ASKER
Is that the only way?? And are you saying if I don't then I cannot use the tables in the secured database if I am in the unsecured database?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You can also use the OPENQUERY, OPENDATASOURCE or OPENROWSET functions to open tables or file that are not on your current server.>>>>>>> It still has to be a linke server - correct?
OPENQUERY is the only one that actually uses a previously defined linked server name.
The other two do not use a previously defined linked server name. They use the same mechanism anyway though.
The other two do not use a previously defined linked server name. They use the same mechanism anyway though.
You just create a linked server and hard code the login details into it.
Linked server are pretty slow though.
Look up sp_addlinkedserver