Category: SQL Server
Using FETCH and OFFSET to get N records in SQL Server
In SQL Server , you can use the OFFSET and FETCH and apply paging and retreive N records at a time. OFFSET AND FETCH clause are part of the ORDER BY clause and hence you must include the ORDER BY clause. For example , you might want to skip the first 4 records and retrieve 5 records from the query , you could use the…
SQL Server Error Code – 4004 unicode data in a unicode-only collation
In this blog post, you’ll learn more about the SQL Server Error Code 4004 and the error message description that is shown SQL Server Error Code 4004 SQL Server Error Description for the Code :4004 Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.
SQL Server Error Code – 7847 xml data was found in the parameter ‘%.*
In this blog post, you’ll learn more about the SQL Server Error Code 7847 and the error message description that is shown SQL Server Error Code 7847 SQL Server Error Description for the Code :7847 XML data was found in the parameter ‘%.*ls’ which is not an XML parameter. Please entitize any invalid XML character data in this parameter, or pass the parameter in typed…
SQL Server Error Code – 8019 the incoming tabular data stream (tds) r
In this blog post, you’ll learn more about the SQL Server Error Code 8019 and the error message description that is shown SQL Server Error Code 8019 SQL Server Error Description for the Code :8019 The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Parameter %d (“%.*ls”): Data type “0x%02X” (CLR type) has an invalid user type specified.
SQL Server Error Code – 15297 the certificate, asymmetric key, or priv
In this blog post, you’ll learn more about the SQL Server Error Code 15297 and the error message description that is shown SQL Server Error Code 15297 SQL Server Error Description for the Code :15297 The certificate, asymmetric key, or private key data is invalid.
SQL Server Error Code – 17891 resource monitor (0x%lx) worker 0x%p app
In this blog post, you’ll learn more about the SQL Server Error Code 17891 and the error message description that is shown SQL Server Error Code 17891 SQL Server Error Description for the Code :17891 Resource Monitor (0x%lx) Worker 0x%p appears to be non-yielding on Node %ld. Memory freed: %I64d KB. Last wait: %ls. Last clerk: type %ls, name %ls. Approx CPU Used: kernel %I64d…
SQL Server Error Code – 28017 the message has been dropped because the
In this blog post, you’ll learn more about the SQL Server Error Code 28017 and the error message description that is shown SQL Server Error Code 28017 SQL Server Error Description for the Code :28017 The message has been dropped because the target service broker is unreachable.
SQL Server Error Code – 33087 %s_msg property of the key returned by e
In this blog post, you’ll learn more about the SQL Server Error Code 33087 and the error message description that is shown SQL Server Error Code 33087 SQL Server Error Description for the Code :33087 %S_MSG property of the key returned by EKM provider doesn’t match the expected value
SQL Server Error Code – 45190 ‘%ls’ is an invalid name because it cont
In this blog post, you’ll learn more about the SQL Server Error Code 45190 and the error message description that is shown SQL Server Error Code 45190 SQL Server Error Description for the Code :45190 ‘%ls’ is an invalid name because it contains one or more unsupported unicode characters.
SQL Server Error Code – 10654 refresh of snapshot view failed because
In this blog post, you’ll learn more about the SQL Server Error Code 10654 and the error message description that is shown SQL Server Error Code 10654 SQL Server Error Description for the Code :10654 Refresh of snapshot view failed because lock could not be obtained on the database.
SQL Server Error Code – 13171 conversation handle
In this blog post, you’ll learn more about the SQL Server Error Code 13171 and the error message description that is shown SQL Server Error Code 13171 SQL Server Error Description for the Code :13171 conversation handle
SQL Server Error Code – 15418 only members of the sysadmin role or the
In this blog post, you’ll learn more about the SQL Server Error Code 15418 and the error message description that is shown SQL Server Error Code 15418 SQL Server Error Description for the Code :15418 Only members of the sysadmin role or the database owner may set the database compatibility level.