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
SQL Server Error Code – 20503 invalid ‘%s’ value in ‘%s’. the publicat
In this blog post, you’ll learn more about the SQL Server Error Code 20503 and the error message description that is shown SQL Server Error Code 20503 SQL Server Error Description for the Code :20503 Invalid ‘%s’ value in ‘%s’. The publication is not enabled for ‘%s’ updatable subscriptions.
SQL Server Error Code – 33527 error occured while initializing the sec
In this blog post, you’ll learn more about the SQL Server Error Code 33527 and the error message description that is shown SQL Server Error Code 33527 SQL Server Error Description for the Code :33527 Error occured while initializing the security functions lookup table. This might be because the installation of SQL Server is corrupted and a required file is missing.
SQL Server Error Code – 4134 metadata stored on disk for computed col
In this blog post, you’ll learn more about the SQL Server Error Code 4134 and the error message description that is shown SQL Server Error Code 4134 SQL Server Error Description for the Code :4134 Metadata stored on disk for computed column ‘%.*ls’ in table ‘%.*ls’ did not match the column definition. In order to avoid possible index corruption, please drop and recreate this computed…
SQL Server Error Code – 15186 the server principal is set as the execu
In this blog post, you’ll learn more about the SQL Server Error Code 15186 and the error message description that is shown SQL Server Error Code 15186 SQL Server Error Description for the Code :15186 The server principal is set as the execution context of a trigger or event notification and cannot be dropped.
SQL Server Error Code – 7694 failed to pause catalog for backup. back
In this blog post, you’ll learn more about the SQL Server Error Code 7694 and the error message description that is shown SQL Server Error Code 7694 SQL Server Error Description for the Code :7694 Failed to pause catalog for backup. Backup was aborted.
SQL Server Error Code – 7942 dbcc %ls scanning ‘%.*ls’ table…
In this blog post, you’ll learn more about the SQL Server Error Code 7942 and the error message description that is shown SQL Server Error Code 7942 SQL Server Error Description for the Code :7942 DBCC %ls scanning ‘%.*ls’ table…
SQL Server Error Code – 8461 an internal service broker error detecte
In this blog post, you’ll learn more about the SQL Server Error Code 8461 and the error message description that is shown SQL Server Error Code 8461 SQL Server Error Description for the Code :8461 An internal service broker error detected. Possible database corruption. Run DBCC CHECKDB.
SQL Server Error Code – 21237 there is a push subscription to publishe
In this blog post, you’ll learn more about the SQL Server Error Code 21237 and the error message description that is shown SQL Server Error Code 21237 SQL Server Error Description for the Code :21237 There is a push subscription to Publisher ‘%s’. Only pull and anonymous subscriptions can be copied.