Category: SQL Server

SQL Server Error Code – 18835 encountered an unexpected text informati

In this blog post, you’ll learn more about the SQL Server Error Code 18835 and the error message description that is shown SQL Server Error Code 18835 SQL Server Error Description for the Code :18835 Encountered an unexpected Text Information End (TIE) log record. Last Text Information Begin (TIB) processed: (textInfoFlags 0x%x, coloffset %ld, newSize %I64d, oldSize %I64d),  text collection state %d. Contact product support.

SQL Server Error Code – 21387 the expanded dynamic snapshot view defin

In this blog post, you’ll learn more about the SQL Server Error Code 21387 and the error message description that is shown SQL Server Error Code 21387 SQL Server Error Description for the Code :21387 The expanded dynamic snapshot view definition of one of the articles exceeds the system limit of 3499 characters. Consider using the default mechanism instead of the dynamic snapshot for initializing…

SQL Server Error Code – 41126 operation on the local availability repl

In this blog post, you’ll learn more about the SQL Server Error Code 41126 and the error message description that is shown SQL Server Error Code 41126 SQL Server Error Description for the Code :41126 Operation on the local availability replica of availability group ‘%.*ls’ failed.  The local copy of the availability group configuration does not exist or has not been initialized.  Verify that the…

Using BETWEEN clause to specify range of values in SQL Query

In SQL Server 2014 , you can use the BETWEEN clause to specify a range of values in the search criteria. How to specify a range of values in a Query in SQL Server ? For example , you want to to query the Employee table to display the employees having the birthdate between 1969-01-29 and 1975-12-01′ , you can use the BETWEEN clause as…