Are you using column aliases in the order by?

Sue

Then do it based upon the availability group itself. You'd still need to modify the query. You didn't notice any issues when you tested the change of the setup to...

Thanks for posting back and I hope you have your sanity back now 🙂

Sue

You would need to change your logic to check at the database level using sys.dm_hadr_database_replica_states to determine primaries and secondaries.

Sue

If you check the Users Guide for SQL Server on RDS, it list the features supported and not supported. If you scroll down to the list of features NOT supported,...

You would need to move away from using MSSQLXML dialect. You can select data using FOR XML to return XML data.

Sue

Probably not - see the Unicode...

Using multiserver administration vs linked servers are really two different things. You can accomplish some what you are looking at but they are very different and implemented differently. You push...

A few thoughts.....You'd want to use some monitoring outside of SQL Server to see if it's running. What do you use to monitor the VM host since it appears that...

You need to use a Unicode data type like nvarchar -

ALTER TABLE YourTable
ALTER COLUMN YourColumn NVARCHAR(MAX)

Sue

For Windows authentication, you can use "Be made using the logins current security context" OR you can also select the login, select impersonate but don't include a remote user or...

You absolutely can use windows authentication (or SQL logins) with linked servers.

It looks like you don't have delegation, Kerberos configured to support the passing of credentials. Everything in the chain...

If the duplicates are just based on Fname, Lname and which of the duplicates you delete doesn't matter, you can use a CTE along the lines of:

WITH...

The naming convention with appending _MSSQL_DBCC<NN> to database name.mdf is what's used by the DBCC CHECKDB process for creating the internal snapshot. It should have cleaned up after the DBCC...

I think it's a fairly safe bet that he uses GP for controlled and audited data modifications (OLTP), and wants to use other tools (eg, Access) for read-only reporting...