Comments
Sort by recent activity
I'm having a very similar problem, though it seems like it only happend one time.
I get the same PK failure mentioned above, on my table of 35 million rows.
I run a dbcc checkident (tablename) and get
Checking identity information: current identity value '35364482', current column value '35367482'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
I know I had run a Data Compare and sync earlier that day on a different table, and a data compare and sync on that table a couple of weeks ago.
so I reseeded and all is well.
I use SQL Data Compare 8 all the time and on many db's, and this is the first and only time this happened.
I downloaded 8.0.2 per the update feature. Is this kind of thing resolved?
Dan / comments
I'm having a very similar problem, though it seems like it only happend one time.
I get the same PK failure mentioned above, on my table of 35 million rows.
I run a dbcc checkident (tablename) and ...
Not using AD in my case is not an option. I've upgraded to the version posted here, and it still just gives me the same blank tab, not working / comments
Not using AD in my case is not an option. I've upgraded to the version posted here, and it still just gives me the same blank tab, not working
I found an error message in your logs: Error Number:-2146893019,State:0,Class:20 24 Apr 2018 16:17:43.219 [1] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database list System.Data.SqlClient.SqlException (0x80131904): A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) ---> System.ComponentModel.Win32Exception (0x80004005): The certificate chain was issued by an authority that is not trusted It seems that if I use an AD account, and select Encrypt the connection, and Trust Certificate (it's self-signed in our case) then SQL Search fails. If I turn off the encryption in the connection it works. / comments
I found an error message in your logs:Error Number:-2146893019,State:0,Class:2024 Apr 2018 16:17:43.219 [1] ERROR RedGate.SQLSearch.Addin.Tab.DatabaseConnector - Could not load database listSystem....
But, I will note, concocting an SQL account, and using it did work, it's just not an acceptable solution. / comments
But, I will note, concocting an SQL account, and using it did work, it's just not an acceptable solution.
Mine gets results. Are you connected? / comments
Mine gets results. Are you connected?
I'm having this same problem (SQL Prompt 9.4.16.9097), but I don't have any other extensions installed (that I know of) except other Red-Gate products. This forum has been quite for 8 months. Any news on this issue? / comments
I'm having this same problem (SQL Prompt 9.4.16.9097), but I don't have any other extensions installed (that I know of) except other Red-Gate products. This forum has been quite for 8 months. Any...
Same problem for me, as described above. I have 12.0.28.3138. I unchecked schema, but the objects still show, and I can't recheck the box, or uncheck any filter box. All filters are locked.
When I close SQL Compare, and reopen, and rerun the compare, it shows a few items different, etc. When I click Schema in the filters, no checkbox changes, so they are still locked, but now I show all objects.
Perhaps I'm just using this tool incorrectly. When I'm unchecking the schema box, I expect all schema objects to be hidden, but no other changes. What it seems I'm getting is that it's hiding the schema objects, but removes my filter option of exclude all objects of schema type = 'datasync'. These are two different function classes / comments
Same problem for me, as described above. I have 12.0.28.3138. I unchecked schema, but the objects still show, and I can't recheck the box, or uncheck any filter box. All filters are locked.
When...
It seems to have fixed itself overnight, so I don't know what the real issue was. Yes we do have NoScript, but our local network is already white listed, so that was not a change. / comments
It seems to have fixed itself overnight, so I don't know what the real issue was. Yes we do have NoScript, but our local network is already white listed, so that was not a change.
All of my searching online seems to generate suggestions and/or solutions for connections using AD/Integrated Security, some tips include switching to SQL Server authentication as a work around.
We are all ready using SQL Server Authentication, so none of these suggestions actually apply, and clearly, they are not the solution. / comments
All of my searching online seems to generate suggestions and/or solutions for connections using AD/Integrated Security, some tips include switching to SQL Server authentication as a work around.
We...
No further information is logged. / comments
No further information is logged.