Comments
Sort by recent activity
I'd also like to get the project browser back, it contains more information that what I would normally put into file names. And if you are bringing it back, maybe you can add an optional description/comment field to it to better differentiate multiple comparison projects in the same database, would be especially helpful on the DataCompare side. / comments
I'd also like to get the project browser back, it contains more information that what I would normally put into file names. And if you are bringing it back, maybe you can add an optional descriptio...
Sam:
It looks like this is fixed now, currently using v12.0.33.3389
Thanks,
Jens / comments
Sam:
It looks like this is fixed now, currently using v12.0.33.3389
Thanks,
Jens
David:
Yes, the error messages are only generated one time when opening the project in the project dialog. The errors themselves are reported back to us from the SQL Server instances as we set up alert notification emails for failed login attempts. So, SQL DataCompare (and SQLCompare as well) actually not not produce any error messages themselves. If I press the refresh button for the database drop-down box or proceed with a comparison then no error messages are being generated. Below si the SQL code to set up notification for login error 18452.
USE [msdb]
GO
IF EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'QSQL08OCR: Login Error 18452')
EXEC msdb.dbo.sp_delete_alert @name=N'Servername: Login Error 18452'
GO
EXEC msdb.dbo.sp_add_alert @name=N'Servername: Login Error 18452',
@message_id=18452,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@notification_message=N'Login failed for user . Reason: Not associated with a trusted SQL Server connection.',
@category_name=N'SQL Server Agent Alerts',
@job_id=N'00000000-0000-0000-0000-000000000000'
GO
EXEC msdb.dbo.sp_update_notification @alert_name=N'Servername: Login Error 18452', @operator_name=N'SQL Server Agent Alert Notification Group', @notification_method = 1
GO
/ comments
David:
Yes, the error messages are only generated one time when opening the project in the project dialog. The errors themselves are reported back to us from the SQL Server instances as we set up a...
Mark:
The target SQL Server instance is located in a different domain, maybe that's the critical difference. Our SQL Server instance then creates to login failure warnings:
DESCRIPTION: SSPI handshake failed with error code 0x8009030c, state 14 while establishing a connection with integrated security; the connection has been closed. Reason: AcceptSecurityContext failed. The Windows error code indicates the cause of failure. [CLIENT: x.x.x.x].
Login Error 18452: DESCRIPTION: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. [CLIENT: x.x.x.x]
COMMENT: Login failed for user . Reason: Not associated with a trusted SQL Server connection. / comments
Mark:
The target SQL Server instance is located in a different domain, maybe that's the critical difference. Our SQL Server instance then creates to login failure warnings:
DESCRIPTION: SSPI handsh...
Sam:
We used to be able to select multiple rows of tables/views and then when we clicked on the checkbox it would select all of the selected tables/views. Right now, this only seems to work when I press the space bar. Also at least in v11 I could double-click on a table and the WHERE clause editor would pop up, this is also not working in v12.
And as a general feedback, v12 of both SQLCompare and SQLDataCompare has had so many bugs so far that I am really disappointed by RedGate. V12 right now feels like a beta release and not a production release and I am unable to clear v12 in our environment for production use for fear of additional bugs that might affect our usage. It is also very annoying if UX features are being removed from v11 to v12 and these removals are then not even listed in the release notes. In my mind this seems to indicate a lack of proper change control and quality assurance processes as the missing UX features should be immediately discoverable by even a casual user of your tools.
Don't get me work, I love your tools but the v12 roll-out is very disappointing. / comments
Sam:
We used to be able to select multiple rows of tables/views and then when we clicked on the checkbox it would select all of the selected tables/views. Right now, this only seems to work when I ...
Aaron:
Sorry for the late reply but I can confirm that this bug is fixed in your latest release.
Thanks,
Jens / comments
Aaron:
Sorry for the late reply but I can confirm that this bug is fixed in your latest release.
Thanks,
Jens
David:
the private build fixed this particular issue. However, I've got a new one for you, exists both in the latest public release as well as this private build:
USE tempdb;
GO
IF EXISTS (SELECT 1 FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[repo]') AND type IN (N'U'))
DROP TABLE [dbo].[repo];
GO
CREATE TABLE [dbo].[repo] ([whse_id] [INT] IDENTITY(1, 1) NOT NULL
, [effbeg_date] [DATE] NOT NULL)
ON [PRIMARY];
GO
SELECT r.*
FROM repo r
INNER JOIN (SELECT TOP 100
whse_id
, MAX(effbeg_date) AS effbeg_date
FROM repo
GROUP BY whse_id) ro
ON r.whse_id = ro.whse_id
AND r.effbeg_date = ro.effbeg_date;
GO
The subquery inside the inner join will inherit the "r" alias from the outer table, resulting in a broken query. / comments
David:
the private build fixed this particular issue. However, I've got a new one for you, exists both in the latest public release as well as this private build:
USE tempdb;
GO
IF EXISTS (SELECT ...
David:
Thanks for the private build, this issue is fixed now. / comments
David:
Thanks for the private build, this issue is fixed now.
This seems to be fixed in 6.4.0.642.
Thanks for the quick turn-around.
Jens / comments
This seems to be fixed in 6.4.0.642.
Thanks for the quick turn-around.
Jens