Also, Microsoft has some documentation on what to try:

https://docs.microsoft.com/en-us/sql/relational-databases/database-mail/database-mail-mail-queued-not-delivered?view=sql-server-ver15

The important tip they offer is:

If the last attempt did not start the external program, verify that the Database Mail External Program...

I'd start by checking the logs.  Logs on the source and the destination servers.  Both SQL and Windows logs.

Personally, I would look at getting a reporting tool like RedGate SQL Monitor (it is what I use, I do not work for RedGate).

Now, in my mind, a failed job...

So since you are ordering by a column you are not using in the SELECT list, you have 3 options if you are using the DISTINCT keyword:

1 - add the...

If operator ID and badge ID are unique in the Operator table (ie it is a 1:1 mapping of operator ID to badge ID), then that isn't going to be...

I was thinking about this and is the data accurate/valid as it is currently?

What I mean is since you are getting duplicates, that makes me think that a single badgeID...

What is the value of the following:

string strConnection = ConfigurationManager.AppSettings["GroupStatus"];

?

My thoughts are that strConnection is connecting to MASTER or the user specified in the connection string has master as the...

I think first you need to understand the difference between a database snapshot and a backup.  The snapshot just marks a point in time of the current database state and...

The documentation says:

AUTO

This option allows SQL Server Database Engine to select the lock escalation granularity that's appropriate for the table schema.

If the table is partitioned, lock escalation will be allowed...

My first step when doing the statistics time or IO related analysis is to turn off the execution plan.  That is going to skew your information.  I would also recommend...

I think the easiest way is going to be by casting it to VARBINARYA(MAX) and then manually going through.

So something like this:

SELECT CAST('HELLO' AS VARBINARY(MAX))

Which gives you:

0x48454C4C4F

0X...

Was doing a bit of googling on the ACE 12 and 16 drivers and found this article:

https://techcommunity.microsoft.com/t5/sql-server-support/dbf-file-name-is-truncated-to-8-characters/ba-p/1493456

Apparently in some versions of the driver, the file name is truncated to be...

On a slightly different note, I would be hesitant about using the MONEY data type as it is an approximate data type.  NUMERIC is likely going to be a better...

quick google:

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/063bc0c2-5201-4c4f-a4d0-0c20f31c64e2/what-are-the-remote-logins

Linked servers can use remote logins too.

Here is how to add a remote login:

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addremotelogin-transact-sql?view=sql-server-ver15

In the end, it REALLY depends on what you want to capture.  What data is interesting to you and will save your bacon in the event something seems wrong.  Can...