Category: SQL Server
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.
SQL Server Error Code – 3633 the operating system returned the error
In this blog post, you’ll learn more about the SQL Server Error Code 3633 and the error message description that is shown SQL Server Error Code 3633 SQL Server Error Description for the Code :3633 The operating system returned the error ?%ls? while attempting ?%ls? on ?%ls? at ?%hs'(%d).
SQL Server Error Code – 6832 for xml auto cannot generate a url addre
In this blog post, you’ll learn more about the SQL Server Error Code 6832 and the error message description that is shown SQL Server Error Code 6832 SQL Server Error Description for the Code :6832 FOR XML AUTO cannot generate a URL address for binary data if a primary key is also binary.
SQL Server Error Code – 15715 setting automatic tuning option %.*ls to
In this blog post, you’ll learn more about the SQL Server Error Code 15715 and the error message description that is shown SQL Server Error Code 15715 SQL Server Error Description for the Code :15715 Setting Automatic Tuning option %.*ls to DEFAULT is not allowed while in CUSTOM database tuning mode for database %.*ls.
SQL Server Error Code – 41362 filestream container ‘%.*ls’ cannot be a
In this blog post, you’ll learn more about the SQL Server Error Code 41362 and the error message description that is shown SQL Server Error Code 41362 SQL Server Error Description for the Code :41362 FILESTREAM container ‘%.*ls’ cannot be added. Either the server is out of memory or the container path is too long.
SQL Server Error Code – 8552 regopenkeyex of \”%ls\” failed: %ls.
In this blog post, you’ll learn more about the SQL Server Error Code 8552 and the error message description that is shown SQL Server Error Code 8552 SQL Server Error Description for the Code :8552 RegOpenKeyEx of \”%ls\” failed: %ls.
SQL Server Error Code – 12301 nullable columns in the index key are no
In this blog post, you’ll learn more about the SQL Server Error Code 12301 and the error message description that is shown SQL Server Error Code 12301 SQL Server Error Description for the Code :12301 Nullable columns in the index key are not supported with %S_MSG.
SQL Server Error Code – 14698 powershell subsystem
In this blog post, you’ll learn more about the SQL Server Error Code 14698 and the error message description that is shown SQL Server Error Code 14698 SQL Server Error Description for the Code :14698 PowerShell Subsystem
SQL Server Error Code – 17196 preparing for eventual growth to %d gb w
In this blog post, you’ll learn more about the SQL Server Error Code 17196 and the error message description that is shown SQL Server Error Code 17196 SQL Server Error Description for the Code :17196 Preparing for eventual growth to %d GB with Hot Add Memory.
SQL Server Error Code – 20047 you are not authorized to perform this o
In this blog post, you’ll learn more about the SQL Server Error Code 20047 and the error message description that is shown SQL Server Error Code 20047 SQL Server Error Description for the Code :20047 You are not authorized to perform this operation.
SQL Server Error Code – 21055 invalid value for parameter %s specified
In this blog post, you’ll learn more about the SQL Server Error Code 21055 and the error message description that is shown SQL Server Error Code 21055 SQL Server Error Description for the Code :21055 Invalid value for parameter %s specified for %s.
SQL Server Error Code – 35317 the statement failed because specifying
In this blog post, you’ll learn more about the SQL Server Error Code 35317 and the error message description that is shown SQL Server Error Code 35317 SQL Server Error Description for the Code :35317 The statement failed because specifying %S_MSG is not allowed when creating a columnstore index. Consider creating a columnstore index without specifying %S_MSG.
SQL Server Error Code – 40087 replica with the specified version is no
In this blog post, you’ll learn more about the SQL Server Error Code 40087 and the error message description that is shown SQL Server Error Code 40087 SQL Server Error Description for the Code :40087 Replica with the specified version is not found.