here's a snippet which checks for database owners and job owners: you will need to run this on each server:

DECLARE @name VARCHAR(128)
SELECT @name...

Active directory will have a list of all servers, which you could then use a WMI query to query services,and get the names of each instance on the server...
then...

do you have all three elements needed, the binary image, the filename and extension in your table?

SQL Server itself does not have tools for sending data to files,...

i hope this helps:
this is the extended events definition i use for a deadlock graph:
IF NOT EXISTS(SELECT * FROM [sys].[server_event_sessions] [dxs] WHERE [dxs].[name] = 'Deadlock_Tracking')

you can install the 32 bit side by side if you execute the package with an optional flag.

make sure you open an Administrative command prompt window, and run...

i would guess that although you said the TCP is set up correctly, it sounds to me like one instance is using a dynamic port for connections, and the other...

i don't ask yes or no or fill in the blank questions, i try to make the interviewer talk about the issue and experiences he has with a particular focus.

it sounds much more like you are looking for whodunnit information...like did Lowell access the Payroll database.
just a plain old login audit will only tell you Lowell connected 40...

probably not.
usually when you send an email to a number of recipients, for example to: currentlyValid@email.com;nolongerValid@email.com;, the SMTP server accepts the message, and database mail receives the SMTP...

i think what you want is a data driven subscription.
generate a view that would build all the parameters for all reports, and create a subscription that populates the parameters...

each client that used to connect to the server, if it has a problem, needs to install the updated SQL Native Client.
it sounds like your machine , specifically needs...

if you are using SQL Database mail, you can query the msdb database:
if the smtp server returns an error, like no such mailbox, you can see it in there.

are you using fully qualified names for the DNS? like myServer.AlphaTangoWhiskey.com, or just the name that has to be resolved, like myServer?
can you test and see if it makes...

for your BCP, can you explicitly convert to varchar, so it's not a custom type on exoprt?

here's a complete example like Sue_H is referencing:
sqlcmd -S stormserver\SQL2016 -Q "SET NOCOUNT ON;select TOP 10 * from DBA.dbo.Algorithm" -o c:\data\myfile.csv -h-1 -s","

The parameter flags...