Category: SQL Server

SQL Server Error Code – 20648 an article already exists for table “%s”

In this blog post, you’ll learn more about the SQL Server Error Code 20648 and the error message description that is shown SQL Server Error Code 20648 SQL Server Error Description for the Code :20648 An article already exists for table “%s” with a different value for the @delete_tracking property. The value must be the same for all publications in which the table is published….

SQL Server Error Code – 22944 could not create the specified database

In this blog post, you’ll learn more about the SQL Server Error Code 22944 and the error message description that is shown SQL Server Error Code 22944 SQL Server Error Description for the Code :22944 Could not create the specified database role ‘%s’ for gating access to change table ‘%s.%s’. Refer to previous errors in the current session to identify the cause and correct any…

SQL Server Error Code – 25606 the extended event engine could not be i

In this blog post, you’ll learn more about the SQL Server Error Code 25606 and the error message description that is shown SQL Server Error Code 25606 SQL Server Error Description for the Code :25606 The Extended Event engine could not be initialized. Check the SQL Server error log and the operating system error log for information about possible related problems.

Sleep Command in SQL Server

If you are looking at writing a query to sleep for or WAIT for a certain amount of time before the query execution can begin , you can use the WAITFOR command. For example , if you want to wait for 1 minute , the query or command for the same will be this.

SQL Server Error Code – 6224 type “%.*ls.%.*ls” is marked for native

In this blog post, you’ll learn more about the SQL Server Error Code 6224 and the error message description that is shown SQL Server Error Code 6224 SQL Server Error Description for the Code :6224 Type “%.*ls.%.*ls” is marked for native serialization, but field “%.*ls” of type “%.*ls.%.*ls” is marked with “System.NonSerializedAttribute”. Native serialization types cannot have fields marked with “System.NonSerializedAttribute”.

SQL Server Error Code – 17116 failed to initialize distributed com; dc

In this blog post, you’ll learn more about the SQL Server Error Code 17116 and the error message description that is shown SQL Server Error Code 17116 SQL Server Error Description for the Code :17116 Failed to initialize distributed COM; DCOM is not installed. Heterogeneous queries and remote procedure calls are disabled. Check the DCOM configuration using Component Services in Control Panel.

SQL Server Error Code – 22958 could not create the function to query f

In this blog post, you’ll learn more about the SQL Server Error Code 22958 and the error message description that is shown SQL Server Error Code 22958 SQL Server Error Description for the Code :22958 Could not create the function to query for all changes for capture instance ‘%s’. Refer to previous errors in the current session to identify the cause and correct any associated…

SQL Server Error Code – 22523 an article cannot use @partition_options

In this blog post, you’ll learn more about the SQL Server Error Code 22523 and the error message description that is shown SQL Server Error Code 22523 SQL Server Error Description for the Code :22523 An article cannot use @partition_options 2 or 3 (nonoverlapping partitions) and be a part of a logical record relationship at the same time. Check article “%s”.

SQL Server Error Code – 41368 accessing memory optimized tables using

In this blog post, you’ll learn more about the SQL Server Error Code 41368 and the error message description that is shown SQL Server Error Code 41368 SQL Server Error Description for the Code :41368 Accessing memory optimized tables using the READ COMMITTED isolation level is supported only for autocommit transactions. It is not supported for explicit or implicit transactions. Provide a supported isolation level…