Contents 

AdeptSQL Diff Reference
Getting started
Connecting to databases
Scanning available servers
Saving and opening comparisons
Running from command line
Working with the schema
Viewing schema differences
Comparing objects side-by-side
Dragging and dropping schema items
Using schema filters
Configuring schema options
Comparing table data
DataDiff overview
Data comparison options
Column configuration file
Special situations comparing data
Executing the SQL
SQL errors and warnings
Keyboard shortcuts
Editing commands and keyboard shortcuts
Using keyboard templates
Choosing debugger's key mapping
Using COM Automation interface
Automating schema comparison
Automating data comparison
Licensing and contact info
Registration of AdeptSQL Diff
Contact information
Version history (last updated for ver. 1.90 [Build 58])

AdeptSQL Diff Online Help

Prev Page Next Page

SQL errors and warnings

Some errors that MS SQL Server reports are actually just warnings. At least, they should not prevent you to proceed executing the rest of script. The most prominent example is when you CREATE PROCEDURE which refers to some undefined object. The server does create it, but then complains that it "Cannot add rows to sysdepends... The SP is still created". Another example is when you try to DROP an object which is not there - this produces an error, but the result is as good as if the object were actually dropped.

The correct reaction in such situations would be to record a warning message and proceed to the next statement, rather then stopping at the failed statement.  So AdeptSQL Diff uses a configuration file which lists error codes for all such exceptions. 

The file is called MSSQLIgnoredErrors.cfg and located in the installation directory of the program. It contains one error number per line, the number must be the first non-blank token on the line (leading blanks are permitted). Any non-digits after the number are considered comments, lines starting from a non-digit or blank lines are ignored. There is no special user interface to modify this files, if you need to do so, do it in a text editor.

 

   
The CHM file was converted to HTML by chm2web software.