doesn't the hotfix work?

'{000C1B7A-164A-4243-9952-01BC82236EB0}' is not the same as '000C1B7A-164A-4243-9952-01BC82236EB0'

some changes on forums are acceptable - SQL ServerCentral change from old format was a "soft" change and not a "I will never use this again" change.

I used to be...

issue with using a "specific login" is that a sysadmin can execute as any login - so it will still not prevent a DBA from doing it which was the...

you can't - and if you don't trust your dba's not to use it then change the process of accessing that linked server so that it is on a black...

bump for visibility.

and speed differences may be to do with settings on ssms vs vb.net

it really shows a lack of understanding of how SSIS Catalog deployment works, even within VS (which does invoke a command line tool to deploy).

everything can be deployed from CI/CD...

what happens if you move that SP to another container, being executed after the other ones?

and most times its some settings on your sp's or locking between SP's - and...

the best, and probably correct, way is to use your visual studio (or vs code) solution (you do have one don't you!!!) and its schema compare.

while there are 2 ways...

doing a select * in SSMS will also be impacted by network speed between workstation and server, workstation processor (and available cpu %), memory, disk speed, and SSMS settings.

if you...

SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and...

This does not bring back any records unfortunately:

SELECT DISTINCT tp.client_id AS Member_ID
, tp.PaidDate AS Paid_Date
, tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate BETWEEN @startDate AND...

SELECT DISTINCT tp.client_id AS Member_ID
     , tp.PaidDate AS Paid_Date
     , tp.DOS
FROM #ins_temp tp
WHERE (@dateChoice = 'Paid_Date' and tp.PaidDate BETWEEN...

That's exactily the reason why we scan and alert for such usage (use of own database name).

Do this for as well sprocs, views, functions, ...)

"Sloppy development" like "start from...

this looks simpler.  may try it.  https://stackoverflow.com/questions/13627337/read-excel-cell-values-with-ssis-script-task   .   not sure if sheet has to be a table or not in order for the select statement to work.

just saw the...