Category: SQL Server
SQL Server Error Code – 8509 import of microsoft distributed transact
In this blog post, you’ll learn more about the SQL Server Error Code 8509 and the error message description that is shown SQL Server Error Code 8509 SQL Server Error Description for the Code :8509 Import of Microsoft Distributed Transaction Coordinator (MS DTC) transaction failed: %ls.
SQL Server Error Code – 9820 the time zone parameter ‘%.*ls’ provided
In this blog post, you’ll learn more about the SQL Server Error Code 9820 and the error message description that is shown SQL Server Error Code 9820 SQL Server Error Description for the Code :9820 The time zone parameter ‘%.*ls’ provided to AT TIME ZONE clause is invalid.
SQL Server Error Code – 9947 warning: identity of full-text catalog i
In this blog post, you’ll learn more about the SQL Server Error Code 9947 and the error message description that is shown SQL Server Error Code 9947 SQL Server Error Description for the Code :9947 Warning: Identity of full-text catalog in directory ‘%ls’ does not match database ‘%.*ls’. The full-text catalog cannot be attached.
SQL Server Error Code – 14060 subscriber parameters specifying provide
In this blog post, you’ll learn more about the SQL Server Error Code 14060 and the error message description that is shown SQL Server Error Code 14060 SQL Server Error Description for the Code :14060 Subscriber parameters specifying provider properties must be NULL for SQL Server subscribers.
SQL Server Error Code – 15100 usage: sp_bindefault defaultname, object
In this blog post, you’ll learn more about the SQL Server Error Code 15100 and the error message description that is shown SQL Server Error Code 15100 SQL Server Error Description for the Code :15100 Usage: sp_bindefault defaultname, objectname [, ‘futureonly’]
SQL Server Error Code – 16934 optimistic concurrency check failed. the
In this blog post, you’ll learn more about the SQL Server Error Code 16934 and the error message description that is shown SQL Server Error Code 16934 SQL Server Error Description for the Code :16934 Optimistic concurrency check failed. The row was modified outside of this cursor.
SQL Server Error Code – 40129 %s_msg database link up with the %s_msg
In this blog post, you’ll learn more about the SQL Server Error Code 40129 and the error message description that is shown SQL Server Error Code 40129 SQL Server Error Description for the Code :40129 %S_MSG database link up with the %S_MSG database ‘%.*ls’ encountered the error: %ls.
SQL Server 2014 Tutorial – Assign TCP/IP Port to Database Engine
Problem Statement You need to change the SQL Server 2014 port number from 1433 to a different port number. Solution By default , SQL Server runs on the port number 1433. You can change it to different port number by following the below steps. 1. Open SQL Server 2014 Configuration Manager from the Windows Start menu. 2. In the left side bar of the Sql…
SQL Server Error Code – 316 the index id %d on table ?%.*ls? (specif
In this blog post, you’ll learn more about the SQL Server Error Code 316 and the error message description that is shown SQL Server Error Code 316 SQL Server Error Description for the Code :316 The index ID %d on table ?%.*ls? (specified in the FROM clause) is disabled or resides in a filegroup which is not online.
SQL Server Error Code – 1062 the top n with ties clause is not allowe
In this blog post, you’ll learn more about the SQL Server Error Code 1062 and the error message description that is shown SQL Server Error Code 1062 SQL Server Error Description for the Code :1062 The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.
SQL Server Error Code – 3123 invalid database name ?%.*ls? specified
In this blog post, you’ll learn more about the SQL Server Error Code 3123 and the error message description that is shown SQL Server Error Code 3123 SQL Server Error Description for the Code :3123 Invalid database name ?%.*ls? specified for backup or restore operation.
SQL Server Error Code – 3716 the %s_msg ?%.*ls? cannot be dropped bec
In this blog post, you’ll learn more about the SQL Server Error Code 3716 and the error message description that is shown SQL Server Error Code 3716 SQL Server Error Description for the Code :3716 The %S_MSG ?%.*ls? cannot be dropped because it is bound to one or more %S_MSG.
SQL Server Error Code – 6862 empty for xml target inline schema uri i
In this blog post, you’ll learn more about the SQL Server Error Code 6862 and the error message description that is shown SQL Server Error Code 6862 SQL Server Error Description for the Code :6862 Empty FOR XML target inline schema URI is not allowed.
SQL Server Error Code – 14713 a management data warehouse cannot be in
In this blog post, you’ll learn more about the SQL Server Error Code 14713 and the error message description that is shown SQL Server Error Code 14713 SQL Server Error Description for the Code :14713 A management data warehouse cannot be installed to SQL Server Express Edition.
SQL Server Error Code – 21228 the specified source object must be a us
In this blog post, you’ll learn more about the SQL Server Error Code 21228 and the error message description that is shown SQL Server Error Code 21228 SQL Server Error Description for the Code :21228 The specified source object must be a user-defined function object if it is going to be published as a ‘func schema only’ type article.
SQL Server Error Code – 3857 the attribute (%ls) is required but is m
In this blog post, you’ll learn more about the SQL Server Error Code 3857 and the error message description that is shown SQL Server Error Code 3857 SQL Server Error Description for the Code :3857 The attribute (%ls) is required but is missing for row (%ls) in sys.%ls%ls.
SQL Server Error Code – 5036 modify file failed. specify logical name
In this blog post, you’ll learn more about the SQL Server Error Code 5036 and the error message description that is shown SQL Server Error Code 5036 SQL Server Error Description for the Code :5036 MODIFY FILE failed. Specify logical name.
SQL Server Error Code – 21600 non-sql server publisher [%s] cannot be
In this blog post, you’ll learn more about the SQL Server Error Code 21600 and the error message description that is shown SQL Server Error Code 21600 SQL Server Error Description for the Code :21600 Non-SQL Server Publisher [%s] cannot be found. Execute sp_helpdistpublishers to view a list of available Publishers.
SQL Server Error Code – 30048 informational: ignoring duplicate thesau
In this blog post, you’ll learn more about the SQL Server Error Code 30048 and the error message description that is shown SQL Server Error Code 30048 SQL Server Error Description for the Code :30048 Informational: Ignoring duplicate thesaurus rule ‘%ls’ while loading thesaurus file for LCID %d. A duplicate thesaurus phrase was encountered in either the section of an expansion rule or the section…
SQL Server Error Code – 35344 merge clause of alter partition statemen
In this blog post, you’ll learn more about the SQL Server Error Code 35344 and the error message description that is shown SQL Server Error Code 35344 SQL Server Error Description for the Code :35344 MERGE clause of ALTER PARTITION statement failed because two nonempty partitions containing a columnstore index cannot be merged. Consider an ALTER TABLE SWITCH operation from one of the nonempty partitions…