Category: SQL Server
SQL Server Error Code – 45455 the operation failed because it is not s
In this blog post, you’ll learn more about the SQL Server Error Code 45455 and the error message description that is shown SQL Server Error Code 45455 SQL Server Error Description for the Code :45455 The operation failed because it is not supported on geo replicated databases. Logical Server ‘%.*ls’, Database ‘%.*ls’, ServiceLevelObjective ‘%.*ls’
SQL Server Error Code – 946 cannot open database ?%.*ls? version %d.
In this blog post, you’ll learn more about the SQL Server Error Code 946 and the error message description that is shown SQL Server Error Code 946 SQL Server Error Description for the Code :946 Cannot open database ?%.*ls? version %d. Upgrade the database to the latest version.
SQL Server Error Code – 2540 the system cannot self repair this error
In this blog post, you’ll learn more about the SQL Server Error Code 2540 and the error message description that is shown SQL Server Error Code 2540 SQL Server Error Description for the Code :2540 The system cannot self repair this error.
SQL Server Error Code – 7403 the ole db provider “%ls” has not been r
In this blog post, you’ll learn more about the SQL Server Error Code 7403 and the error message description that is shown SQL Server Error Code 7403 SQL Server Error Description for the Code :7403 The OLE DB provider “%ls” has not been registered.
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…