Category: SQL Server
SQL Server Error Code – 46651 weeks
In this blog post, you’ll learn more about the SQL Server Error Code 46651 and the error message description that is shown SQL Server Error Code 46651 SQL Server Error Description for the Code :46651 weeks
SQL Server Error Code – 18394 reason: opening the database requested b
In this blog post, you’ll learn more about the SQL Server Error Code 18394 and the error message description that is shown SQL Server Error Code 18394 SQL Server Error Description for the Code :18394 Reason: Opening the database requested by the user failed unexpectedly.
SQL Server Error Code – 3260 an internal buffer has become full.
In this blog post, you’ll learn more about the SQL Server Error Code 3260 and the error message description that is shown SQL Server Error Code 3260 SQL Server Error Description for the Code :3260 An internal buffer has become full.
SQL Server Error Code – 4981 alter table switch statement failed. th
In this blog post, you’ll learn more about the SQL Server Error Code 4981 and the error message description that is shown SQL Server Error Code 4981 SQL Server Error Description for the Code :4981 ALTER TABLE SWITCH statement failed. The lobdata of table ‘%.*ls’ resides in a readonly filegroup ‘%.*ls’.
SQL Server Error Code – 6259 assembly ‘%.*ls’ could not be loaded bec
In this blog post, you’ll learn more about the SQL Server Error Code 6259 and the error message description that is shown SQL Server Error Code 6259 SQL Server Error Description for the Code :6259 Assembly ‘%.*ls’ could not be loaded because it failed verification. %.*ls
SQL Server Error Code – 11741 next value for function cannot be used w
In this blog post, you’ll learn more about the SQL Server Error Code 11741 and the error message description that is shown SQL Server Error Code 11741 SQL Server Error Description for the Code :11741 NEXT VALUE FOR function cannot be used within CASE, CHOOSE, COALESCE, IIF, ISNULL and NULLIF.
SQL Server Error Code – 12114 alter index rebuild does not support reb
In this blog post, you’ll learn more about the SQL Server Error Code 12114 and the error message description that is shown SQL Server Error Code 12114 SQL Server Error Description for the Code :12114 ALTER INDEX REBUILD does not support rebuilding ALL WITH (RESUMABLE=ON) and the ELEVATE_RESUMABLE database scoped configuration is set to FAIL_UNSUPPORTED.
SQL Server Error Code – 15012 the device ‘%s’ does not exist. use sys.
In this blog post, you’ll learn more about the SQL Server Error Code 15012 and the error message description that is shown SQL Server Error Code 15012 SQL Server Error Description for the Code :15012 The device ‘%s’ does not exist. Use sys.backup_devices to show available devices.
SQL Server Error Code – 21757 the subscription is read-only. the publi
In this blog post, you’ll learn more about the SQL Server Error Code 21757 and the error message description that is shown SQL Server Error Code 21757 SQL Server Error Description for the Code :21757 The subscription is read-only. The publication that this subscription synchronizes with allows updates at the Subscriber, but a value of ‘read-only’ was specified for the @update_mode parameter of sp_addsubscription. To…
What is the equivalent of MySQL’s Now() function in SQL Server ?
MySQL has the function Now() which is a Datetime type field which shows the current date as well as the time. What is the equivalent of MySQL’s Now() function in SQL Server ? In SQL Server , you can use the GetDate() function to achieve the same.
How to change the ‘Edit Top 200 Rows’ in SQL Management Studio ?
When working with the SQL Server Management Studio and trying to edit the table records , you would have noticed the context menu option “Edit Top 200 Rows”. How do you change this to display all the records for editing instead of “Edit top 200 rows” in the context menu ? There are couple of ways in which you can do it. 1. Right click…
SQL Server Error Code – 1097 cannot use if update within this create
In this blog post, you’ll learn more about the SQL Server Error Code 1097 and the error message description that is shown SQL Server Error Code 1097 SQL Server Error Description for the Code :1097 Cannot use If UPDATE within this CREATE TRIGGER statement.