I wonder if you could put in the virtual server.db.schema.object and this return different values in an AG. Haven't tested, but that was all I could think of for the...

Yep, fingers crossed he stumbles but throws a lot to Hill 😉

You don't have an alias for the second or third tables.

SELECT
   t1.WEA
   , t2.Date_Time
   , t1.Base1
   , t1.SSI1
   , t2.Base1
   ,...

Correct, no. Any use of a system for insights, queries, backup, etc. is considered active use and production.

Yes, there are free versions of Visual Studio and the BI development workload is free.

You can also use developer of SQL Server for free, or Express.

What's the code you tried to do these?

What if you ran the first time as admin? Or did you?

It's not listed in BOL. Perhaps because there could be some issues with AGs/clustering and having the database move between nodes. In that case, the same database you connected to...

What's the error you get? Also, remove the insert and write the select. What happens here?

Thanks

Glad it made you think

Closing this thread as it has gotten off topic and a little out of hand. My apologies for not doing this sooner.

If you wish to discuss politics or...

The more data you delete in one batch, the larger the log records and and the more locks taken. Often easier and faster to delete in batches rather than one...

That's only a part of what auditing is. Auditing is deciding what information to capture, when, and for this objects. You have the last one, but what information needs to...

What do you need to audit? You still haven't defined this.