Category: SQL Server
SQL Server Error Code – 45410 network resource provider denied access:
In this blog post, you’ll learn more about the SQL Server Error Code 45410 and the error message description that is shown SQL Server Error Code 45410 SQL Server Error Description for the Code :45410 Network resource provider denied access: ‘%ls’.
SQL Server Error Code – 13590 temporal for system_time clause can only
In this blog post, you’ll learn more about the SQL Server Error Code 13590 and the error message description that is shown SQL Server Error Code 13590 SQL Server Error Description for the Code :13590 Temporal FOR SYSTEM_TIME clause can only be set once per temporal table. ‘%.*ls’ has more than one temporal FOR SYSTEM_TIME clause.
SQL Server Error Code – 46723 large object column in global query is n
In this blog post, you’ll learn more about the SQL Server Error Code 46723 and the error message description that is shown SQL Server Error Code 46723 SQL Server Error Description for the Code :46723 Large object column in Global Query is not supported for types other than Nvarchar(MAX), Varchar(MAX), Varbinary(MAX) and Image.
SQL Server 2014 Tutorial – List all the databases in SQL Server using Query
Problem Statement You need to list all the databases that are present in the current SQL Server instance. Solution The list of all the databases from the SQL Server instance can be obtained from the sys.databases object as shown below. 1. Open SQL Management Studio and connect to the SQL Server instance with your login details. 2. Click the “New Query” button and enter the…
SQL Server Error Code – 8391 the usage of 2-part names in drop index
In this blog post, you’ll learn more about the SQL Server Error Code 8391 and the error message description that is shown SQL Server Error Code 8391 SQL Server Error Description for the Code :8391 The usage of 2-part names in DROP INDEX is deprecated. New-style syntax DROP INDEX ON { | }
SQL Server Error Code – 8932 could not find filegroup id %d in sys.fi
In this blog post, you’ll learn more about the SQL Server Error Code 8932 and the error message description that is shown SQL Server Error Code 8932 SQL Server Error Description for the Code :8932 Could not find filegroup ID %d in sys.filegroups for database ‘%ls’.
SQL Server Error Code – 22995 a value for the parameter @retention can
In this blog post, you’ll learn more about the SQL Server Error Code 22995 and the error message description that is shown SQL Server Error Code 22995 SQL Server Error Description for the Code :22995 A value for the parameter @retention cannot be specified when the job type is ‘capture’. Specify NULL for the parameter, or omit the parameter from the statement.
SQL Server Error Code – 41138 cannot accept always on availability gro
In this blog post, you’ll learn more about the SQL Server Error Code 41138 and the error message description that is shown SQL Server Error Code 41138 SQL Server Error Description for the Code :41138 Cannot accept Always On Availability Groups operation operation on database ‘%.*ls’ of availability group ‘%.*ls’. The database is currently processing another operation that might change the database state. Retry the…
SQL Server Error Code – 46529 allowed integer values for first_row are
In this blog post, you’ll learn more about the SQL Server Error Code 46529 and the error message description that is shown SQL Server Error Code 46529 SQL Server Error Description for the Code :46529 Allowed integer values for FIRST_ROW are between and including 1-101
SQL Server Error Code – 6595 could not assign to property ‘%ls’ for t
In this blog post, you’ll learn more about the SQL Server Error Code 6595 and the error message description that is shown SQL Server Error Code 6595 SQL Server Error Description for the Code :6595 Could not assign to property ‘%ls’ for type ‘%ls’ in assembly ‘%ls’ because it is read only.
SQL Server Error Code – 6920 invalid definition for type ‘%ls’. canno
In this blog post, you’ll learn more about the SQL Server Error Code 6920 and the error message description that is shown SQL Server Error Code 6920 SQL Server Error Description for the Code :6920 Invalid definition for type ‘%ls’. Cannot specify use=”prohibited” for attribute ‘%ls’ because there is no corresponding attribute in the base type.
SQL Server Error Code – 8566 unable to commit a prepared transaction
In this blog post, you’ll learn more about the SQL Server Error Code 8566 and the error message description that is shown SQL Server Error Code 8566 SQL Server Error Description for the Code :8566 Unable to commit a prepared transaction from the Microsoft Distributed Transaction Coordinator (MS DTC). Server will restart the database and MS DTC recovery is expected to resolve any in-doubt transaction.