Archive for April, 2008

Using “Execute As” in a Stored Procedure To Access A Separate Database

April 2nd, 2008

Here is a scenario that I often run across. A client wants me to create an add-on to a pre-existing application that runs on SQL Server. I don’t want to touch the existing application and database (let’s call this database PROPIETARY) so I create a separate database (we’ll call it TECHKNOWSOLVE) that queries [...]