Category: SQL Server
SQL Server Error Code – 43016 the value ‘%.*ls’ for configuration ‘%.*
In this blog post, you’ll learn more about the SQL Server Error Code 43016 and the error message description that is shown SQL Server Error Code 43016 SQL Server Error Description for the Code :43016 The value ‘%.*ls’ for configuration ‘%.*ls’ is not valid. The allowed values are ‘%.*ls’.
Checking the version of a SQL Server using T-SQL
There are couple of ways in which you can retreive the version of the SQL Server using T-SQL. Checking the version of a SQL Server using T-SQL 1. using @@VERSION 2. Using SERVERPROPERTY function as shown
SQL Server Error Code – 1086 the for xml and for json clauses are inv
In this blog post, you’ll learn more about the SQL Server Error Code 1086 and the error message description that is shown SQL Server Error Code 1086 SQL Server Error Description for the Code :1086 The FOR XML and FOR JSON clauses are invalid in views, inline functions, derived tables, and subqueries when they contain a set operator. To work around, wrap the SELECT containing…
SQL Server Error Code – 4014 a fatal error occurred while reading the
In this blog post, you’ll learn more about the SQL Server Error Code 4014 and the error message description that is shown SQL Server Error Code 4014 SQL Server Error Description for the Code :4014 A fatal error occurred while reading the input stream from the network. The session will be terminated (input error: %d, output error: %d).
SQL Server Error Code – 11512 the metadata could not be determined bec
In this blog post, you’ll learn more about the SQL Server Error Code 11512 and the error message description that is shown SQL Server Error Code 11512 SQL Server Error Description for the Code :11512 The metadata could not be determined because the statement ‘%.*ls’ in procedure ‘%.*ls’ is not compatible with the statement ‘%.*ls’ in procedure ‘%.*ls’.
SQL Server Error Code – 16116 object ‘%.*ls’ is not a table.
In this blog post, you’ll learn more about the SQL Server Error Code 16116 and the error message description that is shown SQL Server Error Code 16116 SQL Server Error Description for the Code :16116 Object ‘%.*ls’ is not a table.
SQL Server Error Code – 33012 cannot %s_msg signature %s_msg %s_msg ‘%
In this blog post, you’ll learn more about the SQL Server Error Code 33012 and the error message description that is shown SQL Server Error Code 33012 SQL Server Error Description for the Code :33012 Cannot %S_MSG signature %S_MSG %S_MSG ‘%.*ls’. Signature already exists or cannot be added.
SQL Server Error Code – 35231 the specified server instance name, ‘%ls
In this blog post, you’ll learn more about the SQL Server Error Code 35231 and the error message description that is shown SQL Server Error Code 35231 SQL Server Error Description for the Code :35231 The specified server instance name, ‘%ls’, is invalid. Reenter the command specifying a valid instance name.
SQL Server Error Code – 3460 failed to shutdown a database (database
In this blog post, you’ll learn more about the SQL Server Error Code 3460 and the error message description that is shown SQL Server Error Code 3460 SQL Server Error Description for the Code :3460 Failed to shutdown a database (database ID %d) that contains memory-optimized data. Restart SQL Server to bring the database to a consistent state. If the database fails to recover after…
SQL Server Error Code – 10330 alter assembly failed because serializat
In this blog post, you’ll learn more about the SQL Server Error Code 10330 and the error message description that is shown SQL Server Error Code 10330 SQL Server Error Description for the Code :10330 ALTER ASSEMBLY failed because serialization layout of type ‘%s’ would change as a result of a change in type ‘%s’ in the updated assembly. Persisted types are not allowed to…
SQL Server Error Code – 14026 the value of property ‘subscriber_type i
In this blog post, you’ll learn more about the SQL Server Error Code 14026 and the error message description that is shown SQL Server Error Code 14026 SQL Server Error Description for the Code :14026 The value of property ‘subscriber_type is not a supported heterogeneous subscriber type. The value must be 1 (ODBC subscriber), or 3 (OLEDB subscriber).
SQL Server Error Code – 37002 cannot find the database ‘%s’, because i
In this blog post, you’ll learn more about the SQL Server Error Code 37002 and the error message description that is shown SQL Server Error Code 37002 SQL Server Error Description for the Code :37002 Cannot find the database ‘%s’, because it does not exist or you do not have permission to access it.
SQL Server Error Code – 41932 cannot rename managed database ‘%.*ls’ b
In this blog post, you’ll learn more about the SQL Server Error Code 41932 and the error message description that is shown SQL Server Error Code 41932 SQL Server Error Description for the Code :41932 Cannot rename managed database ‘%.*ls’ because it’s currently in use.
SQL Server Error Code – 43011 ‘%.*ls’ is not a valid version.
In this blog post, you’ll learn more about the SQL Server Error Code 43011 and the error message description that is shown SQL Server Error Code 43011 SQL Server Error Description for the Code :43011 ‘%.*ls’ is not a valid version.
SQL Server Error Code – 49903 detected %i64d mb of ram. this is an inf
In this blog post, you’ll learn more about the SQL Server Error Code 49903 and the error message description that is shown SQL Server Error Code 49903 SQL Server Error Description for the Code :49903 Detected %I64d MB of RAM. This is an informational message; no user action is required.
SQL Server Error Code – 15061 the add device request was denied. a phy
In this blog post, you’ll learn more about the SQL Server Error Code 15061 and the error message description that is shown SQL Server Error Code 15061 SQL Server Error Description for the Code :15061 The add device request was denied. A physical device named “%s” already exists. Only one backup device may refer to any physical device name.
SQL Server Error Code – 7644 full-text crawl manager has not been ini
In this blog post, you’ll learn more about the SQL Server Error Code 7644 and the error message description that is shown SQL Server Error Code 7644 SQL Server Error Description for the Code :7644 Full-text crawl manager has not been initialized. Any crawl started before the crawl manager was fully initialized will need to be restarted. Please restart SQL Server and retry the command….
SQL Server Error Code – 14844 remote database ‘%.*ls’ has completed co
In this blog post, you’ll learn more about the SQL Server Error Code 14844 and the error message description that is shown SQL Server Error Code 14844 SQL Server Error Description for the Code :14844 Remote database ‘%.*ls’ has completed copying, and is now online.
SQL Server Error Code – 45391 invalid virtual network configuration %l
In this blog post, you’ll learn more about the SQL Server Error Code 45391 and the error message description that is shown SQL Server Error Code 45391 SQL Server Error Description for the Code :45391 Invalid virtual network configuration %ls. Add Azure recursive resolver virtual IP address 168.63.129.16 at the end of your custom DNS list: %ls. (https://go.microsoft.com/fwlink/?linkid=871071)
SQL Server Error Code – 13802 clr types cannot be used as column types
In this blog post, you’ll learn more about the SQL Server Error Code 13802 and the error message description that is shown SQL Server Error Code 13802 SQL Server Error Description for the Code :13802 CLR types cannot be used as column types in OPENROWSET function with inline schema. These types are not supported in WITH clause.