Are all of the databases on the same server?

If so, don't change the data source. Do it in a stored proc.

Pass in the database name to the proc, and either...

I would ask THEM (your Help Desk people) to contact Microsoft and for THEM to take full responsibility if the proverbial poo hit's the fan because of such an...

Honestly, I doubt you will see much of a difference.  .Net 4.61 gets installed with SQL 2016 and up.  I have seen zero issues with .Net upgrades on a variety...

This sounds more like an issue with the various software or configuration.

There would be no reason to prevent a merge from different branches on the same database, but different objects. ...

I'm confused. Unless multiple people where making changes to the same object, or related objects, you should not get a merge conflict error.

No.

Create a "Main" branch.  You can consider that that "Version 1". Clone that into a "Release" branch. You can call that "Version 2".

When you, or someone else, needs to do...

• This reply was modified 2 years, 9 months ago by Michael L John.

My question is what specific issues are you having that you would expect to be resolved by an edition upgrade?

And, I'm with Grant.  A side by side comparison is the...

I'm thinking that with only 1.5 GB of data,  you could create a series of triggers that insert or update the data into a second database that has primary keys...

If you are actually a...

Can you post the code?  Or a reasonable example?

They are the same.

Yeah.  The coffee kicked in. This worked.  Thanks!

SELECT
DENSE_RANK() OVER (PARTITION BY GuideID, InterviewerID ORDER BY QuestionCategoryID, GuideID, InterviewerID) CategoryNumber
,ROW_NUMBER() OVER (PARTITION BY QuestionCategoryID, GuideID, InterviewerID ORDER BY...

[quote-0 quote=4087836

i just join the team and relatively new to sql server/dba.  i should have said our current team backup practice, not me specifically.  i'd like to have an understanding...

• This reply was modified 3 years ago by Michael L John.

You could restrict this via firewall rules, and possibly some of the things built into Active Directory.

But really, this sound like a maintenance nightmare.  What are you trying to accomplish?

• This reply was modified 3 years ago by Michael L John.

To clarify, you have DatabaseA in production in an AG.  You also have that same database in QA in an AG.

You want to log ship from Prod DatabaseA to QA DatabaseA?

If...