Solved!

With this:

SELECT Name,Templates,Mail

FROM table f

CROSS APPLY OPENJSON(f.detail)

WITH (Name nvarchar(100) ,

Templates nvarchar(max) AS JSON,

Mail nvarchar(100)

)

I obtain this:

test1,"UPDATE",test1@gmail.com

test2,"READ","DELETE",test2@gmail.com

with this:

SELECT f.Name,secondlevel.value,f.Mail

FROM table f

CROSS...

On primary replica, the Log driver is well size, I think this shouldn't be a big issue.

Summarizing, into the D.R. server room I'll power off Sql Server (secondary replica), ...

Hi,

I moved forward in this problem even if I did solve.

One detail probably important: The SSSI package I'm trying to run, has a Sql task (with a parametric connection) which...

When I connect from Server2 to Server1 I'm using Windows Login, the same domain user I use when I connect from Server1.

Thanks

Regards