Comments
Sort by recent activity
Made a snapshot, but I cannot get into the ticket. / comments
Made a snapshot, but I cannot get into the ticket.
Fortunately, we've got a machine which has an older version of SQL Compare 10 on it (version 10.4.8.87; that's the version you recommended to downgrade to, right?), which has the exact same problem.
On that machine I cannot run regedit, but with the Powershell, I can confirm via
Get-ItemProperty 'HKCU:\Software\Red Gate\SQL Compare 10\UI\'
that the TransActionIsolationLevel is set to 'READ COMMITTED'. Can you tell me exactly what you want/mean with a SQL Compare snapshot? I might be able to give you that information.
I think you can simply replicate it as follows. Create the following stored procedure:
CREATE PROC stp_problematic
AS
BEGIN
SELECT * FROM linked_server.database.schema.table
END
That should be enough. Unless there are other settings you'd like to know. / comments
Fortunately, we've got a machine which has an older version of SQL Compare 10 on it (version 10.4.8.87; that's the version you recommended to downgrade to, right?), which has the exact same problem...
I thought I missed something in the original post [image] .
Yes, when I check in the registry, then I see READ COMMITTED at the variable TransactionIsolationLevel at HKCU\Software\Red Gate\SQL Compare 10\UI. That is something I did check before posting this to the topic. / comments
I thought I missed something in the original post .
Yes, when I check in the registry, then I see READ COMMITTED at the variable TransactionIsolationLevel at HKCU\Software\Red Gate\SQL Compare 10\U...
I cannot promise anything. It's on a production environment. We'll see what we can do. If we are going to downgrade, we'll let you know what the results are. / comments
I cannot promise anything. It's on a production environment. We'll see what we can do. If we are going to downgrade, we'll let you know what the results are.