Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Development Tools and Languages
Visual Studio .NET
Developing with Visual Studio .NET
Designing Distributed Applications
Visual Database Tools
Reference
Error Messages in Visual Database Tools
(+) operator ignored.
(+) table reference cannot be joined with more than one table.
The specified syntax cannot be used in this query type.
<Columnname> in expression is not part of the query.
<Featurename> support not available in this server version.
A blank constraint expression is not allowed
A diagram with that name already exists in the database.
A node with the specified name already exists.
A number of rows were affected.
A pair of matching columns is required to create a relationship.
A primary key can't be created on column <Columnname> because it allows null values.
A primary key or index cannot be created on columns with a datatype of <Datatypename>.
A primary key or index cannot have more than <Maximum> columns.
A primary key or unique constraint must be defined for table <Tablename> before it can participate in a relationship.
A relationship cannot contain more than <Maximum> columns.
Adding a formula to the selected column will delete all indexes and relationships it participates in.
Adding a formula to the selected column will delete all relationships it participates in as a foreign key.
ADO Error
ALIAS name is already being used.
ALL cannot be used with CUBE or ROLLUP.
Ambiguous outer join (+) operator.
An error occurred creating the Show Differences window.
An error occurred while working with Visual Database Tools.
An error was encountered while generating create scripts.
An expression cannot be used as a parameter value.
An index already exists for table <Tablename> with the columns <Columnnames>.
An index can't exist on a blank column.
Another user modified this diagram while you were working on it.
Appropriate SQL cannot be generated.
Are you sure that you want to permanently delete the selected database objects?
Are you sure that you want to permanently delete the specified item from the database?
Are you sure you want to delete the selected relationship from your database?
Are you sure you want to permanently delete table <Tablename> from your database?
Are you sure you want to permanently delete the selected tables from your database?
Asterisk (*) may not be used in an indexed view.
At least one of these default pane view check boxes must be selected.
Bad top value.
Both sides of a relationship must have the same number of columns.
Cannot add folder specified.
Cannot assign alias to this field.
Cannot change the default database reference while designers are open.
Cannot convert entry to valid date/time.
Cannot convert to proper type.
Cannot create command file because the current folder contains no scripts that could be included in it.
Cannot create databases on the named server.
Cannot create databases on this server
Cannot debug stored procedures because the SQL Server database is not setup correctly or user does not have permission to execute master.sp_sdidebug.
Cannot delete rows with unknown keys.
Cannot delete these objects because they are open in designers.
Cannot delete this object because it is open in a designer.
Cannot drop the table <tablename> because it does not exist in the system catalog.
Cannot edit rows with unknown keys.
Cannot edit this cell.
Cannot filter this expression.
Cannot find document.
Cannot find Server Explorer database connection.
Cannot find the parameter grid control.
Cannot insert into this expression.
Cannot open encrypted <Viewname>.
Cannot open the .cmd file.
Cannot put expression on select list.
Cannot rename or move a file while it is open in an editor.
Cannot rename or move a folder that contains open files.
Cannot save a document while it is being used by TSQL debugger.
Cannot save query to a file with an extension other than '.dtq'.
Cannot save query to different connection folder.
Cannot select database objects with Unicode object names
Cannot unregister a SQL Server instance while documents are open on databases below this node.
Cannot update this expression.
Cannot use column whose data type is IMAGE or TEXT in this context.
Cannot use LONG data type in this context.
Changing a column data type results in an index that is too large.
Changing the column to the selected data type will delete its indexes and all relationships it participates in.
Changing the column to the selected data type will delete its indexes.
Changing the column to the selected data type will delete relationships.
Changing this alias will result in a duplicate output column name.
Collate clause may not be used in an indexed view.
Column <Columnname> is a computed column, and cannot contribute to foreign keys.
Column <Columnname> is a computed column, and cannot participate in indexes or relationships.
Column <Columnname> is used to enforce the full-text key on table <Tablename> and must be <Maximum> bytes or less.
Column <Columnname> participates in full-text indexing on table <Tablename>. After this change, the column will no longer participate in the table's full-text index.
Column <Columnname> in table <Tablename> participates in index <Indexname>. Columns with a datatype of <Datatypename> cannot participate in indexes or primary keys.
Column cannot be updated.
Column has no name and will be deleted.
Column is the full-text filter for columns that participate in full-text indexing on a table.
Column list not supported for Make Table query.
Column with (+) operator does not reference a valid table.
Columns in this expression have incompatible collations.
Command file name contains invalid character(s).
Comment exceeds n bytes.
Connection failure.
Conversion between the specified data types is not supported on the connected database server.
Could not automatically discover any SQL Server instances.
Could not create the specified file in project.
Data source alias is read only.
Data source base name is read only.
Data Source Locator is missing.
Data type error in expression.
Data type mismatch - no conversion possible.
Data type mismatch - use the CONVERT function.
Database Designer Error
Database object specified already exists. Choose a unique name.
Database Project files must have .dbp file extension.
Database Server Version Run-time Error.
Default Value property cannot be set on column <Columnname> because it is a computed column.
DELETE statement conflicted with COLUMN REFERENCE constraint.
Deleting the selected columns will also delete relationships
Differences were detected in the specified object while you were working on it.
Do you want to prolong your work with the Results pane?
Do you want to save changes in this diagram?
Do you want to save changes in this table?
Do you want to suppress further error messages telling you why records can't be pasted?
Dragged object has invalid database object information.
Editing this default will permanently unbind the named default.
Edits not allowed. Having clause not allowed in an indexed view.
Enter a source control database location.
Enter a source control project name.
Enter an expression in the Column cell first.
Enter an integer between 0 and 100.
Entry must match an item in the list.
Error after function <Functionname>.
Error after predicate near <Stringname>.
Error before EXISTS clause.
Error before EXISTS clause: <Stringname> not recognized.
Error before FROM clause.
Error creating the specified directory.
Error following UNION operator.
Error in column list.
Error in column list: <Stringname> not recognized.
Error in destination table specification.
Error in FROM clause near <Stringname>.
Error in GROUP BY clause near <Stringname>.
Error in GROUP BY clause.
Error in HAVING clause near <Stringname>.
Error in HAVING clause.
Error in INSERT statement.
Error in INSERT statement: <Stringname> not recognized.
Error in join expression.
Error in join expression: <Stringname> not recognized.
Error in list of function arguments: <Stringname> not recognized.
Error in list of values in IN clause.
Error in list of values in IN clause: <Stringname> not recognized.
Error in list of values.
Error in list of values: <Stringname> not recognized.
Error in ON clause near < Stringname>.
Error in optional FROM clause.
Error in ORDER BY clause near <Stringname>.
Error in ORDER BY clause.
Error in SELECT clause: alias <Aliasname> not recognized.
Error in SELECT clause: alias not recognized.
Error in SELECT clause: expression near <Stringname>.
Error in set list in UPDATE clause.
Error in table name or view name in DELETE clause.
Error in table name or view name in DELETE clause: <Stringname> not recognized.
Error in table name or view name in INSERT clause.
Error in table name or view name in INSERT clause: <Stringname> not recognized.
Error in table name or view name in UPDATE clause.
Error in text following query statement: <Stringname>.
Error in values list in INSERT INTO clause.
Error in values list in INSERT INTO clause: <Stringname> not recognized.
Error in WHERE clause near <Stringname>.
Error loading table.
Error moving file specified.
Error moving folder specified.
Error pasting file into project.
Error reloading the project.
Error validating constraint.
Error validating the default for column.
Error validating the formula for column.
Failed to allocate connection.
Failed to design object.
Failed to enumerate objects.
Failed to load source for stored procedure.
Failed to load the function.
Failed to load the package.
Failed to load the trigger.
Failed to open object.
File specified cannot be found.
File specified not found.
Files and folders cannot be named '.' or '..', nor can they contain any of the following characters: # % & * | \ : " < > ? /
Folder specified already exists.
Function argument count error.
Generating create scripts is not supported by the database reference.
Identity seed must be a number containing <Maximum> digits or less.
If you change a file name extension, the file may become unusable.
If you save the view encrypted, you will no longer be able to alter the view definition.
Ignoring illegal use of ALL.
Ignoring ODBC syntax.
Illegal sequence use.
Illegal use of collation clause.
Illegal use of expression list.
Illegal use of outer join operator.
Incomplete column list.
Incomplete parameters list.
Incomplete parameters or column list.
Incomplete SET clause.
Incomplete VALUES list.
Index <Indexname> is used to enforce the full-text key on table <Tablename> and must be <Maximum> bytes or less.
Index <Indexname> is used to enforce the full-text key on table <Tablename> and must be single-column.
Index <Indexname> is used to enforce the full-text key on table <Tablename> and must be unique.
Index <Indexname> is used to enforce the full-text key on table <Tablename> and must not be null.
Index already exists.
Index must have at least one column.
Indexed View must contain a clustered index.
Internal Error.
Internal Error. An error occurred trying to create the database but error information is not available.
Invalid Datatype.
Invalid entries must be resolved before you can exit this pane.
Invalid escape character.
Invalid escape character.
Invalid fill factor; enter an integer between 0 and 100.
Invalid identifier <Stringname>.
Invalid name. You must provide a name for this object.
Invalid or missing expression near <Stringname>.
Invalid or missing expression.
Invalid prefix or suffix characters.
Invalid prefix or suffix characters.
Invalid row index: Goto failed.
Invalid text or symbol.
Invalid view name.
IS operator can only be used with NULL or NOT NULL.
It is only possible to connect to SQL Server Desktop Engine databases and Microsoft Access databases with this version of Visual Studio.
Item specified does not exist in the project directory.
Item specified is currently open in an editor.
Link server object cannot be used as a destination with this query type.
Literal of the correct data type required.
Missing escape character in LIKE predicate.
Missing FROM clause near <Stringname>.
Missing FROM clause.
Missing FROM keyword near <Stringname>.
Missing FROM keyword.
Missing INTO keyword near <Stringname>.
Missing INTO keyword.
Missing or incomplete SELECT clause.
Missing pattern in LIKE predicate.
Missing SET keyword.
Missing subquery correlation name.
Missing subquery or the operator you entered requires parenthesis.
Missing subquery.
Must enter either TRUE or FALSE.
Name entered is not valid.
Name is greater than 30 characters.
Name is too long.
Need alias for this field.
NOT cannot be used in a column cell.
Object name cannot begin with #.
Object with name already exists in the database.
ODBC driver returned an invalid ODBC version and needs to be updated.
ODBC error: <Error>.
One or more selected tables are already on the diagram.
Only one clustered index can be created on table <Tablename>.
Only one ROWGUID column is allowed per table.
OpenRowset cannot be used as a destination with this query type.
Oracle does not allow full outer joins.
Oracle does not support this join syntax.
ORDER BY not supported for CREATE TABLE query.
Out of memory executing database object.
Outer join column may not be used with an IN predicate or subquery.
Outer join operator (+) not allowed as OR operand.
Outer join operator (+) not allowed in the grid pane.
Path name too long.
Poorly formed cast function.
Poorly formed comment.
Primary key or index cannot be created on a column with no name.
Primary key or index cannot be created on column <Columnname> because its data type is <Datatypename>.
Problem running SQL.
Project file is corrupted.
Property cannot be modified.
Query Designer cannot open this query file.
Query Designer Error.
Query Designer requires a database reference.
Query Designer supports no more than 1 table for this type of query.
Query file is corrupted.
Query has executed successfully.
Query or View already exists. Do you want to overwrite it?
Query or View has been modified. Save changes before closing?
Relationship <Relationshipname> was modified or deleted since the diagram was loaded.
Removing the formula from the selected column leaves it with data type that is disallowed in indexes and relationships.
Row limit value should be between <Minimum> and <Maximum>.
Rows pasted.
Runtime Error: Arithmetic overflow error converting expression to data type int.
Save As for a database project must not change the directory.
Select both primary key table and foreign key table before selecting any field for the relationship.
Server Explorer is not working.
Setting for Length must be from <Minimum> to <Maximum>.
Setting for Precision must be from <Minimum> to <Maximum>..
Setting for Scale must be from <Minimum> to <Maximum>.
Some of the selected database objects will not be deleted because they are open in designers.
Some program files are not properly registered on your machine.
Specify a name.
Specify the command file name.
SQL statement could not be parsed.
SQL text cannot be represented in the grid pane and diagram pane.
SQL Verify failed.
Syntax error in table reference.
Syntax error in table reference: <Stringname> not recognized.
Table <Tablename> already exists.
Table <Tablename> has no columns.
Table <Tablename> is marked for deletion and was not added to the diagram.
Table <Tablename> no longer exists in the database.
Table is not in the query definition.
Table name cannot include the double-quote character.
The alias name is too long.
The Allow Nulls property can't be set on a column that is part of the primary key.
The Allow Nulls property can't be set on column <Columnname> because it is an identity column.
The collation properties of columns <Columnname> and <Columnname> do not match.
The columns in table <Tablename> do not match an existing enabled primary key or UNIQUE constraint.
The columns in table <Tablename> do not match an existing primary key or UNIQUE constraint.
The command file name has already been used.
The connection failed.
The database cannot create objects of this type.
The database name is not specified.
The database object no longer exists.
The database row you are modifying no longer exists in the database.
The database server name is not specified.
The datatype of column <Columnname> in the <Tablename> table can't be changed because it participates in index <Indexname>.
The Default Value property can't be set on column <Columnname> because it is an identity column.
The document cannot be found in the database connection.
The existing relationship must have at least one pair of related columns.
The following datatype or size property of <Tablename>.<Columnname> doesn't match <Tablename>.<Columnname>.
The following error was encountered while changing the collation: <Error>.
The following schema-bound objects will be modified.
The identity increment must be a number containing <Maximum> digits or less.
The Identity property can't be set on column <Columnname> because it allows null values.
The Identity property can't be set on column <Columnname> because it has a default value.
The index used to enforce the full-text key for this table will be deleted. Do you want to proceed?
The name is too long.
The name specified is invalid because it is empty, contains invalid characters, or contains more than 128 characters.
The new relationship must have at least one pair of related columns.
The NOT keyword may not be used in a column cell.
The number of selected columns exceeds the number of columns in the target table.
The primary key or UNIQUE constraint cannot be changed until its existing relationships are deleted.
The primary key or UNIQUE constraint cannot be changed while relationships to the existing primary key or UNIQUE constraint are enforced.
The project file uses an old format.
The query cannot be executed because some files are missing or not registered.
The query cannot be run until it has been designed.
This designer does not graphically support the specified SQL construct.
The Query Designer does not support the critical ODBC APIs.
The Query Designer does not support the current ODBC API.
The Results pane has been cleared to conserve server resources.
The specified database reference node already exists.
The specified item is open in an editor.
The specified object already exists.
The specified OR group number is already in use.
The SQL Server does not meet minimum requirements of version 6.5 service pack 3.
The SQL syntax has been verified against the data source.
The stored procedure or scalar function <Name> cannot be specified as a FROM clause reference or as a target for an UPDATE, INSERT or DELETE statement.
The table being loaded into memory has a user-defined data type that is not recognized.
The table must have at least one column that is not computed.
The table-valued function used as target is not an in-line function.
The total size of an index or primary key cannot exceed 900 bytes.
The valid default length range for Oracle CHAR and RAW is 1-255.
The valid default length range for Oracle VARCHAR2 is 1-2000.
The valid default length range for SQL Server data types char, varchar, binary and varbinary is 1-8000.
The valid default length range for SQL Server data types nchar and nvarchar is 1-4000.
The valid range for 'Commit time-out' is 1-65535.
The valid range for 'Limit SQL results sent to Output window' is 1-65535.
The valid range for 'SQL login time-out' is 1-65535.
The valid range for 'SQL query time-out' is 1-65535.
The value for the extended property is too long.
The value you entered is not consistent with the data type or length of the column.
There are no columns selected. Please select one or more columns and re-run the query
There are not enough columns in the subquery select list.
There are not enough columns to match the value list.
There are too many values from the sub-query select list.
There is no unique table in this query.
This cell contains the text string "<NULL>" which may not be processed correctly.
This database version is not supported for designing database diagrams or tables.
This is the default database reference.
This operator cannot be used with columns with data type "uniqueidentifier".
This SQL statement type cannot be used in a view.
To use this feature, you must install SQL Server 2000 Client Tools.
Too many characters for field width.
Too many or too few parameters specified.
Unable to connect to a database specified in the solution.
Unable to create the command file.
Unable to execute create script because it does not begin with CREATE or ALTER.
Unable to execute create script because it does not begin with CREATE or CREATE OR REPLACE.
Unable to execute create script because it does not begin with CREATE.
Unable to execute the create script; the table name is invalid or missing.
Unable to locate data source.
Unable to parse expression.
Unable to parse query text.
Unable to parse statement.
Unable to read object text; the text is encrypted.
Unable to save project file specified.
Unable to save; the object name is invalid or missing.
Undo Checkout succeeded. Compile failed.
Unexpected function type.
Unexpected internal failure while adding create scripts.
Unexpected object type.
Unknown column.
Unknown conversion specification.
Unknown Error
Unquoted alias contains white space.
Use of CONVERT function might be unnecessary.
Use of GROUP BY function in WHERE clause not allowed.
Using source control for stored procedures exposes your database to security risks.
Values for <Propertyname> must lie within the range <Minimum> to <Maximum>.
Values for property must lie within the range x to y.
View already exists in the database.
View definition includes no output columns or no items in the FROM clause.
View has indexes. If you remove schema binding, the indexes will be dropped.
View name cannot begin with #.
Warning: It is likely that the modification will result in a view that cannot be indexed.
Warning: It is likely that the view definition will result in a view that cannot be indexed.
WITH TIES clause requires an ORDER BY clause.
You are about to delete a row or rows.
You are about to paste n rows.
You are not logged in as the database owner or as a user that is a member of the db_owner role. You will not be able to save changes to tables that you do not own.
You cannot change the object type in a script.
You cannot create a view which is self-referenced.
You entered <Number> characters for <Propertyname>. The maximum number of characters allowed is <Maximum>.
You entered x characters for a property; the maximum allowed is y.
You have connected to a version of SQL Server later than SQL Server 2000.
You have made changes to your batch file.
You have modified the text of the stored procedure in the editor only.
You have specified SQL Server authentication, but you have not supplied a user id.
You might not have permission to perform this operation, or the object <Objectname> might no longer exist in the database.
You must save the object first.
You must select a database reference or connection.
Your diagram will be updated with the following changes to match the database before the following tables can be loaded.
Your entry cannot be converted to a valid date time value.
Your Logon does not have CREATE TABLE permission; you might not be able to make certain edits that require this permission.
Your table will be updated with the following changes to match the database.
Expand Minimize
0 out of 2 rated this helpful - Rate this topic

Your entry cannot be converted to a valid date time value.

Visual Studio .NET 2003

In general, the ANSI standard date format is used with databases that represent dates using a true date data type. In contrast, the datetime format is used with databases that support a datetime data type.

For more information, see Rules for Entering Search Values.

Did you find this helpful?
(1500 characters remaining)
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.