OffOn
    Register
    HomeSQL ServerPage 614

    SQL Server

    Showing 12261 - 12280 of 14077 results
    code coder coding computer

    SQL Server Error Msg 2011 – Index hints within a schema-bound object can be applied only to memory optimized tables.

    In this blog post, let’s learn about the error message “2011 – Index hints within a schema-bound object can be...
    Read more
    code coder coding computer

    SQL Server Error Msg 6628 – %.*ls can only process untyped XML. Cast the input value to XML or to a string type.

    In this blog post, let’s learn about the error message “6628 – %.*ls can only process untyped XML. Cast the...
    Read more
    code coder coding computer

    SQL Server Error Msg 20084 – Publication ‘%s’ cannot be subscribed to by Subscriber database ‘%s’.

    In this blog post, let’s learn about the error message “20084 – Publication ‘%s’ cannot be subscribed to by Subscriber...
    Read more
    code coder coding computer

    SQL Server Error Msg 4843 – The bulk data source provider string has a syntax error (‘%lc’) near character position %d.

    In this blog post, let’s learn about the error message “4843 – The bulk data source provider string has a...
    Read more
    code coder coding computer

    SQL Server Error Msg 2203 – %sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as predicates, found ‘%ls’

    In this blog post, let’s learn about the error message “2203 – %sOnly ‘http://www.w3.org/2001/XMLSchema#decimal?’, ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed as...
    Read more
    code coder coding computer

    SQL Server Error Msg 41038 – Failed to enumerate Windows Server Failover Clustering (WSFC) objects (Error code %d).  If this is a WSFC availability group, the WSFC service may not be running or may not be accessible in its current state, or the specified cluster object enumeration handle is invalid.  Otherwise, contact your primary support provider.  For information about this error code, see “System Error Codes” in the Windows Development documentation.

    In this blog post, let’s learn about the error message “41038 – Failed to enumerate Windows Server Failover Clustering (WSFC)...
    Read more

    SQL Server – Limit rows with OFFSET & FETCH

    In this SQL tutorial, you’ll learn  how to use the SQL Server’s OFFSET and FETCH clause to limit the number...
    Read more
    code coder coding computer

    SQL Server Error Msg 1458 – The principal copy of the ‘%.*ls’ database encountered error %d, status %d, severity %d while sending page %S_PGID to the mirror. Database mirroring has been suspended. Try to resolve the error condition, and resume mirroring.

    In this blog post, let’s learn about the error message “1458 – The principal copy of the ‘%.*ls’ database encountered...
    Read more
    code coder coding computer

    SQL Server Error Msg 976 – The target database, ‘%.*ls’, is participating in an availability group and is currently not accessible for queries. Either data movement is suspended or the availability replica is not enabled for read access. To allow read-only access to this and other databases in the availability group, enable read access to one or more secondary availability replicas in the group.  For more information, see the ALTER AVAILABILITY GROUP statement in SQL Server Books Online.

    In this blog post, let’s learn about the error message “976 – The target database, ‘%.*ls’, is participating in an...
    Read more
    code coder coding computer

    SQL Server Error Msg 35244 – Database ‘%.*ls’ cannot be added to availability group ‘%.*ls’.  The database is currently joined to another availability group.  Verify that the database name is correct and that the database is not joined to an availability group, then retry the operation.

    In this blog post, let’s learn about the error message “35244 – Database ‘%.*ls’ cannot be added to availability group...
    Read more
    code coder coding computer

    SQL Server Error Msg 2714 – There is already an object named ‘%.*ls’ in the database.

    In this blog post, let’s learn about the error message “2714 – There is already an object named ‘%.*ls’ in...
    Read more
    code coder coding computer

    SQL Server Error Msg 5193 – Failed to access file due to lease mismatch. Bringing down database.

    In this blog post, let’s learn about the error message “5193 – Failed to access file due to lease mismatch....
    Read more
    code coder coding computer

    SQL Server Error Msg ALTER TABLE SWITCH statement failed on table ‘%.*ls’ because column ‘%.*ls’ does not have the same GENERATED ALWAYS attribute in target and source tables. – 16

    In this blog post, let’s learn about the error message “ALTER TABLE SWITCH statement failed on table ‘%.*ls’ because column...
    Read more
    code coder coding computer

    SQL Server Error Msg 22565 – uses other than day as unit of retention period

    In this blog post, let’s learn about the error message “22565 – uses other than day as unit of retention...
    Read more
    code coder coding computer

    SQL Server Error Msg 1483 – State information for database ‘%.*ls’ – Hardened Lsn: ‘%S_LSN’    Commit LSN: ‘%S_LSN’    Commit Time: ‘%S_DATE’

    In this blog post, let’s learn about the error message “1483 – State information for database ‘%.*ls’ – Hardened Lsn:...
    Read more
    code coder coding computer

    SQL Server Error Msg 8637 – The query processor could not produce a query plan because a USE PLAN hint was used for a query that modifies data while the target table of the modification has an index that is currently being built online. Consider waiting until the online index build is done before forcing the plan, or using another way to tune the query, such as updating statistics, or using a different hint or a manual query rewrite.

    In this blog post, let’s learn about the error message “8637 – The query processor could not produce a query...
    Read more
    code coder coding computer

    SQL Server Error Msg 3903 – The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

    In this blog post, let’s learn about the error message “3903 – The ROLLBACK TRANSACTION request has no corresponding BEGIN...
    Read more
    code coder coding computer

    SQL Server Error Msg 20578 – Replication: agent custom shutdown

    In this blog post, let’s learn about the error message “20578 – Replication: agent custom shutdown” in Microsoft SQL Server,...
    Read more
    code coder coding computer

    SQL Server Error Msg 49933 – ERROR: The MSSQL_SA_PASSWORD environment variable must be set when using the –reset-sa-password option.

    In this blog post, let’s learn about the error message “49933 – ERROR: The MSSQL_SA_PASSWORD environment variable must be set...
    Read more
    code coder coding computer

    SQL Server Error Msg 21311 – Profile used by the Merge Agent to perform rowcount and checksum validation.

    In this blog post, let’s learn about the error message “21311 – Profile used by the Merge Agent to perform...
    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