Tag: SQL Server Errors

SQL Server Error Msg 20512 – Updateable Subscriptions: Rolling back transaction.

SQL Server Error Msg 9506 – The XMLDT method ‘%.*ls’ can only be invoked on columns of type xml.

SQL Server Error Msg 5003 – Database mirroring cannot be enabled while the database has offline files.

SQL Server Error Msg 18348 – Reason: Failed to store database name and collation while revalidating the login on the connection. Check for previous errors.

SQL Server Error Msg 2772 – Cannot access temporary tables from within a function.

SQL Server Error Msg 15233 – Property cannot be added. Property ‘%.*ls’ already exists for ‘%.*ls’.

SQL Server Error Msg 5173 – One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files.  If this is an existing database, the file may be corrupted and should be restored from a backup.

SQL Server Error Msg 3017 – The restart-checkpoint file ‘%ls’ could not be opened. Operating system error ‘%ls’. Correct the problem, or reissue the command without RESTART.

SQL Server Error Msg 4959 – ALTER TABLE SWITCH statement failed. Partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’ and partition %d of %S_MSG ‘%.*ls’ has TEXT filegroup ‘%.*ls’.

SQL Server Error Msg 4067 – CLR type serialization failed because an invalid cookie was specified.

SQL Server Error Msg 21669 – Column [%s] cannot be published because it uses an unsupported data type [%s]. View supported data types by querying msdb.dbo.sysdatatypemappings.

SQL Server Error Msg 17810 – Could not connect because the maximum number of ‘%ld’ dedicated administrator connections already exists. Before a new connection can be made, the existing dedicated administrator connection must be dropped, either by logging off or ending the process.%.*ls

SQL Server Error Msg 20611 – Cannot add the article. Publications that allow transformable subscriptions with Data Transformation Services (DTS) can only include tables and indexed views that are published as tables.

SQL Server Error Msg 6845 – Two (or more) elements named ‘%.*ls’ are optional in the same level. Consider making them direct siblings or map NULL to xsi:nil

SQL Server Error Msg 1940 – Cannot create %S_MSG on view ‘%.*ls’. It does not have a unique clustered index.

SQL Server Error Msg 21827 – The %s parameters have been deprecated and should no longer be used. For more information, see the ‘%s’ documentation.

SQL Server Error Msg 9018 – The log for database ‘%ls’ does not allow user writes.

SQL Server Error Msg 18354 – Reason: Failed to duplicate of security token.

SQL Server Error Msg 40508 – USE statement is not supported to switch between databases. Use a new connection to connect to a different database.

SQL Server Error Msg 1214 – Internal Error.  There are too many parallel transactions.