From the description, I'm thinking the issue is you have a slow report,and if multiple people hit it, it's slow, bogs down the system, etc.

I don't think there...

when you connect via SSMS, it is using the dns and wins services to resolve an name/alias to a specific IP address; therefor since the server already existed, it would...

this is what i use: 
with extremely rare exceptions, I want @@servername to return the name of the machine.
So if I clone VMOriginal as VMNew, when i connect to...

there's an additional table to join to, the msdb.dbo.sysmail_event_log , where the [description] column will tell you exactly what the issue is;
it's typically an error from the mail server, username...

but the Data you provided...

the root of all harddrives are protected. N'D:\MyTrace.log' is invalid due to those protections.
you pretty much HAVE to put files in a subfolder.

I think that's partially incorrect.
what I read is that a linked server featuring the SQLOLEDB  is deprecated, and must be replaced with a server using the SQLNCLI) driver instead.

easy fix, the path for the file is wrong. it has slashes like a UNC path,a s well as a drive letter. it's one or the other. Maybe you mean...

this was kind of interesting, so I imported the file into a varchar max column, and used two CrLf as the delimiter, and the pipe character as the column delimiter(since...

i have a process that does something exactly like this; the issue is the remote server has the "freshest" data, but we want the dbo table available  without significant locking.

for a stored procedure, the EXECUTE AS must name  to a USER in the database

it cannot use a LOGIN who is not an EXPLICIT USER in the database.

if you keep insisting on active connections, then as Gail said, the answer is basically no.
people do not connect to tables.

 you cannot track who is actually...

maybe the system DMV sys.dm_db_index_usage_stats has info you might be looking for?
with that, you could see how many times a table has been accessed,and the lasttime it was accessed,...

Database Mail is asynchronous, so anything using sp_send_dbmail just inserts mail into the table dbo.sysmail_mailitems, which the engine just sends the emails out one at a time anyway.
throughput wise,...