SQL Server 2014 Tutorial – Assign TCP/IP Port to Database Engine

AbundantCode 5 months ago in SQL Server 1

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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 – 3857 the attribute (%ls) is required but is m

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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

AbundantCode 5 months ago in SQL Server 0

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…