Learn Programming and technology with ease @ developerpublish.com

    OffOn
    Register course
    HomePosts tagged “SQL Server Errors”Page 646

    SQL Server Errors

    Showing 12901 - 12920 of 13986 results

    SQL Server Error Msg 1990 – Cannot define an index on a view with ignore_dup_key index option. Remove ignore_dup_key option and verify that view definition does not allow duplicates, or do not index view.

    In this blog post, let’s learn about the error message “1990 – Cannot define an index on a view with...
    Read more

    SQL Server Error Msg 1989 – Cannot enable foreign key constraint ‘%.*ls’ as index ‘%.*ls’ on referenced key is disabled.

    In this blog post, let’s learn about the error message “1989 – Cannot enable foreign key constraint ‘%.*ls’ as index...
    Read more

    SQL Server Error Msg 1988 – Cannot rebuild clustered index ‘%.*ls’ online because it is disabled.

    In this blog post, let’s learn about the error message “1988 – Cannot rebuild clustered index ‘%.*ls’ online because it...
    Read more

    SQL Server Error Msg 1987 – Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘%.*ls’ because its %S_MSG is disabled.

    In this blog post, let’s learn about the error message “1987 – Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘%.*ls’ because...
    Read more

    SQL Server Error Msg 1986 – Cannot replace non-hypothetical index ‘%.*ls’ with a hypothetical index using the DROP_EXISTING option.

    In this blog post, let’s learn about the error message “1986 – Cannot replace non-hypothetical index ‘%.*ls’ with a hypothetical...
    Read more

    SQL Server Error Msg 1985 – Cannot create %S_MSG on view ‘%.*ls’. It contains one or more XML data type methods.

    In this blog post, let’s learn about the error message “1985 – Cannot create %S_MSG on view ‘%.*ls’. It contains...
    Read more

    SQL Server Error Msg 1984 – Index ‘%.*ls’ cannot be created or rebuilt. The specified row length for this index using the vardecimal storage format exceeds the maximum allowed length of ‘%d’ bytes.

    In this blog post, let’s learn about the error message “1984 – Index ‘%.*ls’ cannot be created or rebuilt. The...
    Read more

    SQL Server Error Msg 1983 – Cannot create %S_MSG on view ‘%.*ls’. The function ‘%s’ yields imprecise results. Use a precise system function, or modify the user-defined function to return precise results.

    In this blog post, let’s learn about the error message “1983 – Cannot create %S_MSG on view ‘%.*ls’. The function...
    Read more

    SQL Server Error Msg 1982 – Cannot create %S_MSG on view ‘%.*ls’ because the view references non-deterministic or imprecise member function ‘%.*ls’ on CLR type ‘%.*ls’. Consider removing reference to the function or altering the function to behave in a deterministic way.  Do not declare a CLR function that behaves non-deterministically to have IsDeterministic=true, because that can lead to index corruption. See Books Online for details.

    In this blog post, let’s learn about the error message “1982 – Cannot create %S_MSG on view ‘%.*ls’ because the...
    Read more

    SQL Server Error Msg 1981 – Warning: The maximum length of the row exceeds the permissible limit of %d bytes. For some combination of large values, the insert/update operation will fail.

    In this blog post, let’s learn about the error message “1981 – Warning: The maximum length of the row exceeds...
    Read more

    SQL Server Error Msg 1980 – Index cannot be created on computed column ‘%.*ls’ of table ‘%.*ls’ because the underlying object ‘%.*ls’ has a different owner.

    In this blog post, let’s learn about the error message “1980 – Index cannot be created on computed column ‘%.*ls’...
    Read more

    SQL Server Error Msg 1979 – Cannot use index option ignore_dup_key to alter index ‘%.*ls’ as it enforces a primary or unique constraint.

    In this blog post, let’s learn about the error message “1979 – Cannot use index option ignore_dup_key to alter index...
    Read more

    SQL Server Error Msg 1978 – Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as a key column in an index or statistics.

    In this blog post, let’s learn about the error message “1978 – Column ‘%.*ls’ in table ‘%.*ls’ is of a...
    Read more

    SQL Server Error Msg 1977 – Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’. Only XML Index can be created on XML column ‘%.*ls’.

    In this blog post, let’s learn about the error message “1977 – Could not create %S_MSG ‘%.*ls’ on table ‘%.*ls’....
    Read more

    SQL Server Error Msg 1976 – Cannot create index or statistics ‘%.*ls’ on view ‘%.*ls’ because cannot verify key column ‘%.*ls’ is precise and deterministic. Consider removing column from index or statistics key, marking column persisted in base table if it is computed, or using non-CLR-derived column in key.

    In this blog post, let’s learn about the error message “1976 – Cannot create index or statistics ‘%.*ls’ on view...
    Read more

    SQL Server Error Msg 1975 – Index ‘%.*ls’ row length exceeds the maximum permissible length of ‘%d’ bytes.

    In this blog post, let’s learn about the error message “1975 – Index ‘%.*ls’ row length exceeds the maximum permissible...
    Read more

    SQL Server Error Msg 1974 – Cannot perform the specified operation on %S_MSG ‘%.*ls’ because its clustered index ‘%.*ls’ is disabled.

    In this blog post, let’s learn about the error message “1974 – Cannot perform the specified operation on %S_MSG ‘%.*ls’...
    Read more

    SQL Server Error Msg 1973 – Cannot perform the specified operation on disabled index ‘%.*ls’ on %S_MSG ‘%.*ls’.

    In this blog post, let’s learn about the error message “1973 – Cannot perform the specified operation on disabled index...
    Read more

    SQL Server Error Msg 1972 – Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’. Permission denied to alter the referencing view ‘%.*ls’ while disabling its clustered index.

    In this blog post, let’s learn about the error message “1972 – Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’....
    Read more

    SQL Server Error Msg 1971 – Cannot disable index ‘%.*ls’ on table ‘%.*ls’. Permission denied to disable foreign key ‘%.*ls’ on table ‘%.*ls’ that uses this index.

    In this blog post, let’s learn about the error message “1971 – Cannot disable index ‘%.*ls’ on table ‘%.*ls’. Permission...
    Read more

    Categories

    Archives
    Tags
    c# C# Compiler Errors C# Programs C++ examples C programs csharp DB2 Errors Delphi Errors Download Excel Excel 2016 Excel Automation excel functions excel tips excel tutorials Excel VBA Functions in Excel how to HPE NonStop SQL/MX Java examples Microsoft Microsoft Excel MS Office MySQL Errors Oracle Errors Outlook Errors PolarDB for PostgreSQL Python examples python programs SQL Server SQL Server Errors Sybase Error Message tips tricks troubleshoot Visual Studio Visual Studio 2012 Win32 Windows 11 Windows 11 tutorials Windows BSOD Errors windows phone windows phone 8 Windows Store wp8