Apply the principle of least privilige on a Linked Server connection
Linked Servers are easy to set up in all versions of SQL Server. Using a Linked Server one can connect to databases on the same SQL Server instance, on other instances, other DBMSs such as Oracle, MySQL, Informix and using the appropriae driver (e.g. OLEDB, ODBC, etc.), even Microsoft Access or...
[Read More]