Something to note about Ken's reply, you will want to make sure that the "evaluation" license allows you to do what you are trying to do. I know the...

Thank you all!

Finally I did

• restore to SQL 2008 R2
• set db's compatibility level from 80 to 100
• do backup
• restore this new backup on 2022 🙂

dupe post, original here

https://www.sqlservercentral.com/forums/topic/how-to-restore-on-newer-version%5B/quote%5D

Yes, because when posting here I received "500 Bad Gateway" after very long waiting. Thats why I thougth that posting here is disabled because...

Thanks all,

to be honest I didn't knew logon triggers before. Now I learnt something new 🙂

But I agree that these things are too "buggy". Maybe easy to setup, but hard...

Thanks!

Can you please specify? Are there any pitfalls when I use it

Sorry - I've not seen your first request

Now the briefcase stays visible in my account. So I can give positive...

Yes, it is still an issue.

Today I see that my screenshots in post #3907708 are not visible, too. In these screenshot I showed the CSS...

It's the same on all OS and Browsers I have tested. Wheteher Win10, Debian, OpenBSD, Firefox, Chrome, Edge...

https://www.sqlservercentral.com/briefcase shows the topics in my briefcase for a fraction of...

• This reply was modified 3 years, 4 months ago by  mh.

Of course, when I was doing INSERT, UPDATE or DELETE then I see the difference  when ldf is on different disk

I should have thought more on my loop-select-procedure before writing...

Thank you both.

As always very helpfull comments - I like this forum 🙂

Oh - haha ....a typo

Of course I meant that NON-SSL connections  are a little bit faster than SSL connections.

Hi Brian,

Much thanks for your detailed response.

Your post was very instructive to me.

Thanks for pointing me to the examples on github. I was able to setup Northwind on my test...

@steve-2 Jones: Thanks for the valueable info that encryption is set by protocol in SQL Server.

@Mr. Brian Gale: of course a legitimate recommendation to test with encyption en-/disabled....