Agree with Drew. I would only query employee, but I'd have a trusted FK here.

No strange risk here. no log shipping is taking place because no log backups. The secondary is sitting there. The primary will have issues at some point with space if...

There are scripts here on the site to search for every table and column for data. If I kick this off, what I going to do is scan every row...

The photographer at Redgate had actually seen the park and was wondering if I'd really do it. I thought it was fun.

😉

The Thread is fine, or Twitter. I've usually gone with first to post here is in.

Like...

It's not really relevant here. If you don't think an index persists the value, that's something you need to learn about indexing.

I try to get the questions to...

You are welcome.

Just a note, overall licensing for SQL Server is an admin thing. You need to track and have the licenses for all instances that require them,...

This implies that the Application log is for any authenticated user: https://docs.microsoft.com/en-us/sql/relational-databases/security/auditing/sql-server-audit-database-engine?view=sql-server-2017

Can you script your server audit and post it?