Use contained databases

There is an object called an Application Role that has a password. The idea is to grant permissions to the Application Role and in the application connect...

What result set are you looking for?

Please check out EXECUTE AS in the SQL Server documentation.

I would use db_mail instead.

SQL Server 2012 T-SQL Recipes (Apress, 2012)
Querying Data with Transact-SQL (MSPress, 2017)
T-SQL Fundamentals Third Edition (MSPress, 2016)
T-SQL Querying (MSPress, 2015)
Microsoft SQL...

Using JOIN won't make it faster but it does make it more understandable as you use join to join and where to filter. It's also the standard now.

Or a login trigger

Create a history table with the same schema and an after insert update trigger to write deleted into the history. If your table has modified date and user columns write...

Stored procedures do return select statements so you options are a stored procedure or a table valued function.

If you only connect using the machine name that should be working. If you are connecting using a DNS that isn't 

September 11, 2018 at 10:19 am

#2005266

You must register the DNS as an SPN under the SQL Server Service account for Kerberos delegation to work to pass the token to the linked server.

Post table DDL and inserts of sample data please.