Tips

SQL Compare

• Logging and log files
• Stored Procedures and Functions created with wrong name
• Synchronization scripts may be in incorrect version of SQL syntax
• Extended properties not permitted error (version 5.2)
• CLR Procedures' permissions are not recreated (version 5)
• Support for 'returns NULL on NULL Input' in CLR functions (version 5)
• Project files (scp files) suddenly appear on desktop (version 5)
• Stored procedures using full-text queries fail to synchronize
• When does the synchronization process rebuild tables?
• Unable to begin a distributed transaction error synchronizing databases
• User or role already exists in the current database error
• Clarification on the "Ignore Triggers" option in the SQL Compare command-line version
• Common table expressions returned by User Defined Functions may fail
• Can't compare encrypted text in SQL Server 2005, 2008
• Exception when connecting to SQL Server (Version 6)
• SQL comparison and synchronization automation capabilities
• Error logging in SQL Compare 6.2
• Using Team Foundation Server source control system
• Creating a SQL 2000 compatible database from a SQL 2005 database using SQL Compare
• Support for numbered stored procedures
• SQL Compare 7 Object-level restore
• Index was outside the bounds of the array error when registering databases X64
• HTML reports are generated for identical comparisons
• Comparison may seem slower than necessary
• DEFAULT_SCHEMA clause cannot be used with a Windows group
• SQL Compare may drop and create CLR assemblies
• SDK activation prompt may appear when starting a new SQL Compare project
• Column does not allow nulls. INSERT fails
• This SQL Server has been optimized for x concurrent queries.
• SQL Compare comparison differences
• Using SQL Server Management Studio Express as a query editor
• How to force SQL Compare and SQL Data Compare to use an Encrypted Connection
• Invalid SQL when synchronizing an index to a scripts folder when data compression is specified
• Tips
• Changes to distribution of command line
• Common error messages
• Copying the structure of a database
• Permissions required to use SQL Compare
• Rollback on script failure or cancellation
• Errors in scripts folders
• Logging and log files

all SQL products

• Compatibility of Red Gate tools in 64-bit environments
• Application has encountered an error and needs to close
• Error message after installing SQL Toolbelt - The description for Event ID ( 1 ) in Source ( nview_info ) cannot be found.
• Changing the temporary directory used by the installer
• Toolbelt Installer "hanging" while "scanning volumes"
• Login failing with "trusted SQL Server connection" error when using RunAs

all products

• Some Red Gate products identified as containing a trojan by Anti-Virus software
• Activation may fail with Unknown Error -1
• Product uses web help although a CHM file is available locally
• Argument exception resulting from missing environment variable
• Check for updates may fail when used through proxies
• 'Unidentified Publisher' error when repairing or uninstalling
• Licensing activates product as standard edition
• Moving Red Gate software products to another machine
• Red Gate tools log locations
• The application UI opening slowly when there is no internet access