Category: SQL Server

SQL Server Error Code – 30058 properties of zero length cannot be adde

In this blog post, you’ll learn more about the SQL Server Error Code 30058 and the error message description that is shown SQL Server Error Code 30058 SQL Server Error Description for the Code :30058 Properties of zero length cannot be added to a search property list. Specify a search property name that contains at least one character and that is unique to the specified…

SQL Server Error Code – 13719 system-versioned table schema modificati

In this blog post, you’ll learn more about the SQL Server Error Code 13719 and the error message description that is shown SQL Server Error Code 13719 SQL Server Error Description for the Code :13719 System-versioned table schema modification failed because column ‘%.*ls’ does not have the same sparse storage attribute in tables ‘%.*ls’ and ‘%.*ls’.

SQL Server Error Code – 21128 terminating immediate updating or queued

In this blog post, you’ll learn more about the SQL Server Error Code 21128 and the error message description that is shown SQL Server Error Code 21128 SQL Server Error Description for the Code :21128 Terminating immediate updating or queued updating INSERT trigger because it is not the first trigger to fire. Use sp_settriggerorder procedure to set the firing order for trigger ‘%s’ to first.

SQL Server Error Code – 6529 alter assembly failed because the identi

In this blog post, you’ll learn more about the SQL Server Error Code 6529 and the error message description that is shown SQL Server Error Code 6529 SQL Server Error Description for the Code :6529 ALTER ASSEMBLY failed because the identity of referenced assembly ‘%.*ls’ has changed. Make sure the version, name, and public key have not changed.

SQL Server Error Code – 27166 the installed version of sql server does

In this blog post, you’ll learn more about the SQL Server Error Code 27166 and the error message description that is shown SQL Server Error Code 27166 SQL Server Error Description for the Code :27166 The installed version of SQL Server does not support the installation of the Integration Services server. Update SQL Server, and then try installing the Integration Services server again.

SQL Server 2014 Tutorial – Manage SQL Server services

Problem Statement You need to manage the SQL Server services that are installed on your server machine. Solution Use SQL Server Configuration Manager tool to manage the SQL Server services on your machine. Following are some of the actions that you can perform using the SQL Server Configuration Manager – Start , Stop , Pause , Restart a SQL Server Service – Modify or configure…