Posts
Sort by recent activity
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...
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...
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...
How Do I Interpret the output of sqbmemory?
I'm troubleshooting some failed backups that write to a network share. I've read some posts on this forum about setting the MAXDATABLOCK and MAXTRANSFERSIZE parameters for the sqlbackup procedure....
SQLPrompt Interfering with VSTE DBPro Unit Test Creation
I was attempting to create a Database Unit Test in Visual Studio Team Edition for Database Professionals. Things were going well until I got to the screen to actually design the test. The window ...
Additional Issues with VSTE for DBPro
I am using the RTM edition of Visual Studio Team Edition for Database Professionals. I have found a few issues with the functionality of SQL Prompt 3.5 within the Visual Studio development environ...
"Modify" and "Newname" do not convert to uppercase
The keywords "MODIFY" and "NEWNAME" are not being converted to uppercase as I would like.
I entered the following statement in Management Studio:
ALTER DATABASE Test
modify FILE (
NAME = 'Test_...
Keywords next to character strings
I noticed that SQL Prompt handles keywords differenty when they are followed by a character string.
For example, let's say I have the following SQL code in a script:exec (@vSQL);
If I use...