Posts
Sort by recent activity
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...
Minimum Permissions for Login Used to run Backups
I have recently taken over the administration of my company's implementation of SQL Backup. In our current configuration, we have created a SQL Server login to run the backups. This login has bee...