Activity overview
Latest activity by Wyatt70
ColumnStore Indexes
Does SQL Compare support the new ColumnStore indexes? I two SQL Server 2012 databases. One has ColumnStore indexes, the other does not. When I try to compare them, I get an error "Failed to comp...
Semicolons
I see the product still has that irritating behavior of inserting a space in front of every semicolon. Is there any way to turn off this behavior? If not, can the development team please give us ...
New variation of "An item with the same key ... " error
I am unable to compare two of my databases. Each one has the same problem. There are multiple schemas in these databases, and there are some tables with the same name in both schemas.
If "Treat i...
I changed my SQL Server service to use the LocalSystem account, and I was able to install the server components. Once everything was installed, I switch the SQL Server service back to my preferred account. The backups are running fine.
Just curious, did you remove the "BUILTIN\Administrators" group from your SQL Server instance? I always do, and I am wondering if Red-Gate expects you to be using a service account that is also a member of the Windows Local Administrators group. That might explain why we had to use LocalSystem to complete the installation.
If that is the case, I think Red-Gate should reconsider. There are many situations in which you would not want members of the LocalAdministrators group to have sysadmin privileges on instances of SQL Server. / comments
I changed my SQL Server service to use the LocalSystem account, and I was able to install the server components. Once everything was installed, I switch the SQL Server service back to my preferred...
Hmm ... let me see if I can install it with the LocalSystem account. / comments
Hmm ... let me see if I can install it with the LocalSystem account.
Unable to Install Server Components
I am attempting a new installation of SQL Backup 5.2.0.002824. The installation of the GUI succeeds, but I get an error when I attempt to "Install or Upgrade Server Components" on the default inst...
I'll speak to the developer, she may be able to modify it to implement IComparable. Thanks for the assistance! / comments
I'll speak to the developer, she may be able to modify it to implement IComparable. Thanks for the assistance!
I caputure the SQL statements in Profiler, and I was able to run them all in Management Studio. As for the comparison key, it is not included for the tables that have a primary key, but it IS included for the tables that do NOT have primary keys. / comments
I caputure the SQL statements in Profiler, and I was able to run them all in Management Studio. As for the comparison key, it is not included for the tables that have a primary key, but it IS incl...
The tables in question are in two different schemas. All but one of the tables that work are in one schema, and all of the tables in this schema have primary keys. The tables in the other schema do not have primary keys, so I have to create a custom comparison key for each table that includes all columns in the table. / comments
The tables in question are in two different schemas. All but one of the tables that work are in one schema, and all of the tables in this schema have primary keys. The tables in the other schema ...
Problem with Comparison of CLR type
SQL Server Version: 9.0.3054
SQL Data Compare Version: 6.0.0.1124
I am attempting to compare two databases, each of which has several tables with a column whose data type is a CLR data type. The c...