Category: SQL Server
SQL Server Error Code – 21131 there are existing subscriptions to hete
In this blog post, you’ll learn more about the SQL Server Error Code 21131 and the error message description that is shown SQL Server Error Code 21131 SQL Server Error Description for the Code :21131 There are existing subscriptions to heterogeneous publication ‘%s’. To add new articles, first drop the existing subscriptions to the publication.
SQL Server Error Code – 39093 ‘predict’ function does not take paramet
In this blog post, you’ll learn more about the SQL Server Error Code 39093 and the error message description that is shown SQL Server Error Code 39093 SQL Server Error Description for the Code :39093 ‘PREDICT’ function does not take parameters of varchar(max), nvarchar(max) or varbinary(max) type except for ‘MODEL’ parameter.
SQL Server Error Code – 1785 introducing foreign key constraint ?%.*l
In this blog post, you’ll learn more about the SQL Server Error Code 1785 and the error message description that is shown SQL Server Error Code 1785 SQL Server Error Description for the Code :1785 Introducing FOREIGN KEY constraint ?%.*ls? on table ?%.*ls? may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY…
SQL Server Error Code – 4616 you cannot perform this operation for th
In this blog post, you’ll learn more about the SQL Server Error Code 4616 and the error message description that is shown SQL Server Error Code 4616 SQL Server Error Description for the Code :4616 You cannot perform this operation for the resource database.
SQL Server Error Code – 14049 stored procedures for replication are th
In this blog post, you’ll learn more about the SQL Server Error Code 14049 and the error message description that is shown SQL Server Error Code 14049 SQL Server Error Description for the Code :14049 Stored procedures for replication are the only objects that can be used as a filter.
SQL Server Error Code – 21178 data transformation services (dts) prope
In this blog post, you’ll learn more about the SQL Server Error Code 21178 and the error message description that is shown SQL Server Error Code 21178 SQL Server Error Description for the Code :21178 Data Transformation Services (DTS) properties cannot be set because the publication does not allow transformable subscriptions using DTS. To allow transformable subscriptions, you must drop the publication and then and…
SQL Server Error Code – 21425 the @publisher parameter may not be null
In this blog post, you’ll learn more about the SQL Server Error Code 21425 and the error message description that is shown SQL Server Error Code 21425 SQL Server Error Description for the Code :21425 The @publisher parameter may not be NULL for heterogeneous publishers.
SQL Server Error Code – 21624 unable to locate the registered oracle o
In this blog post, you’ll learn more about the SQL Server Error Code 21624 and the error message description that is shown SQL Server Error Code 21624 SQL Server Error Description for the Code :21624 Unable to locate the registered Oracle OLEDB provider, OraOLEDB.Oracle, at distributor ‘%s’. Make certain that a current version of the Oracle OLEDB provider is installed and registered at the distributor….
SQL Server Error Code – 33536 vbs enclave attestation failed. attestat
In this blog post, you’ll learn more about the SQL Server Error Code 33536 and the error message description that is shown SQL Server Error Code 33536 SQL Server Error Description for the Code :33536 VBS enclave attestation failed. Attestation status: ‘%ls’, substatus: ‘%ls’. For more information, see ‘https://go.microsoft.com/fwlink/?linkid=2099553’.
SQL Server Error Code – 1847 the current version of the operating sys
In this blog post, you’ll learn more about the SQL Server Error Code 1847 and the error message description that is shown SQL Server Error Code 1847 SQL Server Error Description for the Code :1847 The current version of the operating system doesn?t support auto-recovered Volume Shadow Copy (VSS) snapshots.
SQL Server Error Code – 6629 the result of the column expression for
In this blog post, you’ll learn more about the SQL Server Error Code 6629 and the error message description that is shown SQL Server Error Code 6629 SQL Server Error Description for the Code :6629 The result of the column expression for column “%ls” is not compatible with the requested type “XML”. The result must be an element, text node, comment node, processing instruction, or…
How to rename a column in SQL Server ?
One of the options for the user to rename a column in SQL Server is using the so_rename stored procedure and specifying the parameters. Here’s the syntax of the sp_rename. For example , if you want to rename the column description in the temp_abundantcode table to comment , this is how it looks.