Good to know, thanks for the info, Alejandro!

Good to know, thanks for the info, Alejandro!

Figured out the issue.  Looks like the SQL Server version being newer for the new SQL instance meant that I needed to connect to it through a newer version of...

Thank you both for the suggestions!  I will give these a try.

Unfortunately, for what we're trying to do, these have to remain SQL views, not stored procedures.

Is what I'm asking not possible in SQL Server?

Hi Sue,

I apologize for using the term "linked servers," that is inaccurate in this case.  This issue has nothing to do with linked servers.

DatabaseABC and DatabaseXYZ...

Think I found the issue.  Looks like installing to the root of a drive is bad practice and can break permissions on that drive.  This has been fixed.

HanShi,

Thank you for the response!  I'll give this solution a try.

You're right, we'll need to take a closer look at what might have caused the seeding to become misaligned, but It looks like that script may have resolved our issue...

Thanks for the response, John.

This is occurring in the subscription (test) DB.

After running the script you gave me, I'm getting the following message:

"current identity...

Thanks for the responses everyone.  I'll give these a try.  🙂

Thank you for the suggestions so far!

There have been questions about whether the size increase relates to the data or log file. I can confirm that the sys.master_files.size we're...

Thanks for the suggestions! Sounds like SSIS might be the closest thing there is to some sort of industry standard for this type of automation.

Thank you both of you for your responses. I'll give these a try and see if they make a difference!