I think the point is more about using schemas for setting up permissions rather than always focusing on object level permissions. Basically looking at granting the permissions on schemas rather...

Good point - I don't believe there is one. Usually issues like your delete one are posted in one of the forums under SQLServerCentral.com catagories - the Issues or Suggestions...

You should be fine without reinitializing - It would start the synchronizing to catch up once it's online

Sue

You use the undocumented extended stored procedure xp_qv. This post has a sample query to use:

When will my SQL Server Evaluation Edition expire?

Sue

The export to XML doesn't export anything related to the layout or pagination. It just exports the data in XML form, that's it. You'd use it for an XML message,...

No idea at all how you are doing this. As a guess, If you use an XMLA script, you can make that dynamic and append a date stamp.You can find...

Normally you can start the service, it doesn't require a SQL Server restart.

Sue

I never kept a list of everything but the migration assistant will pick up most things and provide workarounds and additional information for the ones the assistant didn't convert. And...

Another FYI on the permissions....using an admin share is going to result in some security issues as well. Using servername\e$ is the admin share.

Sue

Sorry...typo. I meant the latest version of SSMA.

The download instruction include: In addition to the SSMA program files, you must also install the SSMA for Oracle Extension Pack on the...

Are you using the latest version of SSMS? And did you also install the SSMA for Oracle Extension Pack that comes with the download?

This is a link to download the...

Try this link for 2016 SP2 and see if it works:

Microsoft SQL Server 2016 Service Pack 2 (SP2)

A lot of the links no longer work. A lot of...

Really appreciate it when people provide updates, which you do so thanks!

I'm guessing your fine now and that was the issue.

Sue

The SPN needs to match the availability group name. Refer to this article for more info:

Connect to an Always On availability group listener

Sue

What do you mean, Neil? The question states the data is encrypted in 2016, moved to 2017. There's no "up to date" here. The algorithm changes. You can't xfer...