Category: SQL Server
SQL Server Error Code – 18264 database backed up. database: %s, creati
In this blog post, you’ll learn more about the SQL Server Error Code 18264 and the error message description that is shown SQL Server Error Code 18264 SQL Server Error Description for the Code :18264 Database backed up. Database: %s, creation date(time): %s(%s), pages dumped: %I64d, first LSN: %s, last LSN: %s, number of dump devices: %d, device information: (%s). This is an informational message…
How to Declare a variable in SQL Server ?
You will most likely declare a variable in the SQL Server and use it in the SQL Statements. You can use the DECLARE statement and specify the variable and datatype and optionally provide a default value. For example , You can declare an NewEmployeeJobTitle variable using the DECLARE statement and provide a default value as ‘Chief Executive Officer’ DECLARE @NewEmployeeJobTitle nvarchar(50) = ‘Chief Executive Officer’;…
SQL Server Error Code – 201 procedure or function ?%.*ls? expects pa
In this blog post, you’ll learn more about the SQL Server Error Code 201 and the error message description that is shown SQL Server Error Code 201 SQL Server Error Description for the Code :201 Procedure or function ?%.*ls? expects parameter ?%.*ls?, which was not supplied.
SQL Server Error Code – 1935 cannot create index. object ?%.*ls? was
In this blog post, you’ll learn more about the SQL Server Error Code 1935 and the error message description that is shown SQL Server Error Code 1935 SQL Server Error Description for the Code :1935 Cannot create index. Object ?%.*ls? was created with the following SET options off: ?%.*ls?.
SQL Server Error Code – 8636 the query processor could not produce a
In this blog post, you’ll learn more about the SQL Server Error Code 8636 and the error message description that is shown SQL Server Error Code 8636 SQL Server Error Description for the Code :8636 The query processor could not produce a query plan because there is a subquery in the predicate of the full outer join. This is not supported for distributed queries.
SQL Server Error Code – 14660 database compatibility level is too low.
In this blog post, you’ll learn more about the SQL Server Error Code 14660 and the error message description that is shown SQL Server Error Code 14660 SQL Server Error Description for the Code :14660 Database Compatibility Level is too low. Compatibility Level must be Version80 or higher.
SQL Server Error Code – 14891 table ‘%.*ls’ cannot be a target of an u
In this blog post, you’ll learn more about the SQL Server Error Code 14891 and the error message description that is shown SQL Server Error Code 14891 SQL Server Error Description for the Code :14891 Table ‘%.*ls’ cannot be a target of an update or delete statement with an OUTPUT clause because it has the REMOTE_DATA_ARCHIVE option enabled.
SQL Server Error Code – 16642 conflict logging retention period parame
In this blog post, you’ll learn more about the SQL Server Error Code 16642 and the error message description that is shown SQL Server Error Code 16642 SQL Server Error Description for the Code :16642 Conflict logging retention period parameter is required if conflict logging is turned on.
SQL Server Error Code – 21773 the distribution database ‘%s’ cannot be
In this blog post, you’ll learn more about the SQL Server Error Code 21773 and the error message description that is shown SQL Server Error Code 21773 SQL Server Error Description for the Code :21773 The distribution database ‘%s’ cannot be opened due to inaccessible files. The database will be dropped, but distribution database cleanup tasks will not occur. Check the database and server error…
SQL Server Error Code – 27128 the name ‘%ls’ is not valid. it consists
In this blog post, you’ll learn more about the SQL Server Error Code 27128 and the error message description that is shown SQL Server Error Code 27128 SQL Server Error Description for the Code :27128 The name ‘%ls’ is not valid. It consists of characters that are not allowed.
SQL Server Error Code – 40167 a paired clouddb fabric node failed and
In this blog post, you’ll learn more about the SQL Server Error Code 40167 and the error message description that is shown SQL Server Error Code 40167 SQL Server Error Description for the Code :40167 A paired CloudDB fabric node failed and database %d must be shutdown.
SQL Server Error Code – 13287 cryptographic provider
In this blog post, you’ll learn more about the SQL Server Error Code 13287 and the error message description that is shown SQL Server Error Code 13287 SQL Server Error Description for the Code :13287 cryptographic provider