All you need to do in the database is associate the user with the login.  The permissions come over with the database so you don't need to touch them.  From...

Why does it need to be improved - does it not work?

I would start by making sure you have the same number of ENDs as BEGINs.  Then I would consider...

https://docs.microsoft.com/en-us/sql/t-sql/statements/collations?view=sql-server-ver15#examples

John

You'll need to change the collation of the databases or of the server (not a trivial task), or insert COLLATE clauses in your code.  You'll probably find you need a...

Yes, I agree, Phil.  Casting to date preserves sargability; converting to varchar doesn't.

John

Well, if those logins have a default database that doesn't exist, or if you are specifying a non-existent database at connect time, then the connections will fail.

John

It tells you how to evaluate the SET options in the documentation for dm_exec_plan_attributes.  You can use the bitwise operators to do it programmatically.

I don't know whether there's anything...

In which case there must be multiple rows in Base_Risks with the same [pol_numpol contract_id] and [sor_ident contract_update_id] for the value for which you're getting the duplicates.

John

Without seeing your data, it's very difficult to help you.  What happens if you run only the query in the echantillon CTE?  Do you get the duplicate then?

John

Temp tables will be created in tempdb regardless of your database context.  Yes, of course creating them takes resource - disk space, processor, memory, IO.  Do you have a link...

I like it!  And you can simplify it further:

    SELECT  batch_Id
         ,  get_customeVal_3 =...

I'd guess that if XACT_ABORT is OFF then only the statement that's running at the moment of the timeout will be rolled back.  Whether that rollback occurs gracefully and expeditiously...

WITH Last24Hrs AS (
SELECT
VisitID
,IdentifierID
,ActivityDateTime
,DATEADD(HOUR,-24,MAX(ActivityDateTime) OVER (PARTITION BY VisitID)) AS _24HrsBefore
FROM #T1
)
SELECT
VisitID
,IdentifierID
,ActivityDateTime
FROM Last24Hrs t
WHERE t.ActivityDateTime >= t._24HrsBefore;

John

This is a good reference for connection strings.  If you can't find what you're looking for there, just include the SET statement in your code.  Probably best to do...

OK, are you telling me that in case I'm interested, or do you have a follow-up question?  Note that it says "Default connection options" in that dialog box.  As I...