CMS is always Windows auth only,
but in the same section of Registered Servers, you can add Local Server Groups, and credentials for SQL logins can be saved there;
the...

I strongly recommend using Registered Servers with both Central Management Servers and Local Server Groups, a little used feature in SSMS that can be a huge boost to your organizing...

i suspect what you really need to do is produce an exception report to find data that was inserted or updated, but that now violates a business rule, which is...

your paste was huge, and it also appears to be a partial paste, as it's not terminated correctly. huge things like that belong in an attachment, really, and not pasted...

I built a simple query to insertmax length varchars for  all the fields.
I am able to insert and select via TSQL.

could the issue be coming from your...

i think your performance problem is probably the multiple OR statements; that's likely causing a table scan.
WHERE ( [PropertyAddress].[LocAddress1] != [PropertyAddress].[bioAddress1]
                   OR [PropertyAddress].[LocAddress2] != [PropertyAddress].[bioAddress2]

that's actually a setting in SSMS that you can toggle back and forth.
Assuming SSMS 2016, If you go to Tools>>Options>>SQL Server ObjectExplorer>>Scripting
You currently have a checkmark for...

kudos to you sir, nice job. playing with xquery and xml takes a bit of work!
I made some trivial changes to the query for the dataset, in order to...

Chandan you would probably get better, more specific help if you...

i think that resetting the database user(s) to match the login is the backwards way to do it; you have to re-do it with every restore.

i prefer to...

Anyone here who is a Chapter Leader or Volunteer for your local SQL User Group, I'm just taking over the South Florida SQL server User Group, and if you have...

I'm never surprised when this happens; 
seven months ago, a sharp reader noticed a copy paste of one of mine: i don't care personally, it wasn't rocket science to script...

Only Visual Studio Professional can connect with TFS; so the SSDT or Community Versions cannot use TFS. I've had to go through that issue at my job, everyone had SSDT,...