If someone logs into the SQL Server instance, and their context is master, or say db_a. If they execute a "Use db_b", the trigger won't capture this. In fact, not...

OK, the process I'd follow is to treat these like ETL. I want to "load" the files and then move them.

My script would need to:

• Find the next file to...

Good and bad. worked a bit and then spent the last day and evening with my...

Are you sure this is the only code that was run? I did this twice in a TDE database that was set to read only with no error or warning.

The old forums definitely did not. It was a simple toggle that was set each time you posted. No preference saved other than the last way you posted.

We have never allowed this...

I personally don't...

Apologies, the link is for an article due to publish in a few days. I'll remove it for now.

Bugs are being fixed and things repaired. This is the first I've seen/heard of this. It's been filed.

Are you keeping a database in norecovery mode (or standby)? IF so, log shipping would be easier.

Are you removing old log files from here? There is no good way to...

1. I'm not sure what you are looking for here. This doesn't quite make sense in English.

2. As Lowell mentioned, you can get some of this information with Extended Events...

These are two disparate databases, so as Sue mentioned, you need to enable TDE on the subscriber. Different cert and DEK used. These databases aren't linked and the data that...

I can't see that page (GDPR and all that). If you can repost on the GH Issues page, that will help

Interesting discussion.

My main point that started this is that natural keys become problematic for the GDPR and other regulation because of the hassle of decoupling the data from a human...

We've loved and supported the project, but George has moved on and the site is on hold. We want to continue to grow the project with help from others. Please...