Category: SQL Server
SQL Server Error Code – 4010 the incoming tabular data stream (tds) p
In this blog post, you’ll learn more about the SQL Server Error Code 4010 and the error message description that is shown SQL Server Error Code 4010 SQL Server Error Description for the Code :4010 The incoming tabular data stream (TDS) protocol stream is incorrect. The Query Notification TDS header contained errors.
SQL Server Error Code – 7663 option ‘with no population’ should not b
In this blog post, you’ll learn more about the SQL Server Error Code 7663 and the error message description that is shown SQL Server Error Code 7663 SQL Server Error Description for the Code :7663 Option ‘WITH NO POPULATION’ should not be used when change tracking is enabled.
SQL Server Error Code – 8186 function ‘%.*ls’ can be used only on use
In this blog post, you’ll learn more about the SQL Server Error Code 8186 and the error message description that is shown SQL Server Error Code 8186 SQL Server Error Description for the Code :8186 Function ‘%.*ls’ can be used only on user and system tables.
SQL Server Error Code – 13049 built-in function name
In this blog post, you’ll learn more about the SQL Server Error Code 13049 and the error message description that is shown SQL Server Error Code 13049 SQL Server Error Description for the Code :13049 built-in function name
SQL Server Error Code – 452 collate clause cannot be used on user-de
In this blog post, you’ll learn more about the SQL Server Error Code 452 and the error message description that is shown SQL Server Error Code 452 SQL Server Error Description for the Code :452 COLLATE clause cannot be used on user-defined data types.
SQL Server Error Code – 8138 more than 16 columns specified in foreig
In this blog post, you’ll learn more about the SQL Server Error Code 8138 and the error message description that is shown SQL Server Error Code 8138 SQL Server Error Description for the Code :8138 More than 16 columns specified in foreign key column list, table ‘%.*ls’.
SQL Server Error Code – 21334 cannot initialize message queuing-based
In this blog post, you’ll learn more about the SQL Server Error Code 21334 and the error message description that is shown SQL Server Error Code 21334 SQL Server Error Description for the Code :21334 Cannot initialize Message Queuing-based subscription because the platform is not Message Queuing %s compliant
SQL Server Error Code – 40577 the constraint ‘%ls’ is not supported in
In this blog post, you’ll learn more about the SQL Server Error Code 40577 and the error message description that is shown SQL Server Error Code 40577 SQL Server Error Description for the Code :40577 The constraint ‘%ls’ is not supported in a federated database.
Using Where clause in T-SQL Query
If you want to restrict the results of the query to only the records that you need instead of returning all the records from the table , you can use the WHERE clause to filter the records. You can simply specify the WHERE clause and also specify the conditions that the rows must meet. How to Filter records using WHERE clause in SQL Server ?…
SQL Server Error Code – 16115 ‘%.*ls’ option’s value must be provided
In this blog post, you’ll learn more about the SQL Server Error Code 16115 and the error message description that is shown SQL Server Error Code 16115 SQL Server Error Description for the Code :16115 ‘%.*ls’ option’s value must be provided as string.
SQL Server Error Code – 20535 removes replication agent history from t
In this blog post, you’ll learn more about the SQL Server Error Code 20535 and the error message description that is shown SQL Server Error Code 20535 SQL Server Error Description for the Code :20535 Removes replication agent history from the distribution database.
SQL Server Error Code – 3422 database %ls was shutdown due to error %
In this blog post, you’ll learn more about the SQL Server Error Code 3422 and the error message description that is shown SQL Server Error Code 3422 SQL Server Error Description for the Code :3422 Database %ls was shutdown due to error %d in routine ?%hs?. Restart for non-snapshot databases will be attempted after all connections to the database are aborted.