Category: SQL Server
SQL Server Error Code – 11653 cannot execute as the user ‘%.*ls’ becau
In this blog post, you’ll learn more about the SQL Server Error Code 11653 and the error message description that is shown SQL Server Error Code 11653 SQL Server Error Description for the Code :11653 Cannot execute as the user ‘%.*ls’ because it does not exist.
SQL Server Error Code – 23510 item with name already exists in contain
In this blog post, you’ll learn more about the SQL Server Error Code 23510 and the error message description that is shown SQL Server Error Code 23510 SQL Server Error Description for the Code :23510 Item with name already exists in container.
SQL Server Error Code – 33131 principal ‘%ls’ has a duplicate display
In this blog post, you’ll learn more about the SQL Server Error Code 33131 and the error message description that is shown SQL Server Error Code 33131 SQL Server Error Description for the Code :33131 Principal ‘%ls’ has a duplicate display name. Make the display name unique in Azure Active Directory and execute this statement again.
SQL Server Error Code – 40585 can not perform replica operation becaus
In this blog post, you’ll learn more about the SQL Server Error Code 40585 and the error message description that is shown SQL Server Error Code 40585 SQL Server Error Description for the Code :40585 Can not perform replica operation because this node is not the forwarder for this partition.
SQL Server Error Code – 9229 unknown option name ‘%.*ls’ present in n
In this blog post, you’ll learn more about the SQL Server Error Code 9229 and the error message description that is shown SQL Server Error Code 9229 SQL Server Error Description for the Code :9229 Unknown option name ‘%.*ls’ present in notification options identifier. The following are valid option names: ‘Service’, ‘Broker Instance’, ‘Local Database’. Option names cannot be quoted.
SQL Server Error Code – 9539 selective xml index feature is not suppo
In this blog post, you’ll learn more about the SQL Server Error Code 9539 and the error message description that is shown SQL Server Error Code 9539 SQL Server Error Description for the Code :9539 Selective XML Index feature is not supported for the current database version
SQL Server Error Code – 13261 event attribute or predicate source
In this blog post, you’ll learn more about the SQL Server Error Code 13261 and the error message description that is shown SQL Server Error Code 13261 SQL Server Error Description for the Code :13261 event attribute or predicate source
SQL Server Error Code – 15065 all user ids have been assigned.
In this blog post, you’ll learn more about the SQL Server Error Code 15065 and the error message description that is shown SQL Server Error Code 15065 SQL Server Error Description for the Code :15065 All user IDs have been assigned.
SQL Server Error Code – 15537 login ‘%.*ls’ does not have access to se
In this blog post, you’ll learn more about the SQL Server Error Code 15537 and the error message description that is shown SQL Server Error Code 15537 SQL Server Error Description for the Code :15537 Login ‘%.*ls’ does not have access to server.
SQL Server Error Code – 21275 cannot publish the schema-bound view ‘%l
In this blog post, you’ll learn more about the SQL Server Error Code 21275 and the error message description that is shown SQL Server Error Code 21275 SQL Server Error Description for the Code :21275 Cannot publish the schema-bound view ‘%ls’. The value specified for the @type parameter must be “indexed view schema only” (for snapshot or transactional replication) or “indexed view logbased” (for transactional…
SQL Server Error Code – 9233 the option ‘service’ must be specified i
In this blog post, you’ll learn more about the SQL Server Error Code 9233 and the error message description that is shown SQL Server Error Code 9233 SQL Server Error Description for the Code :9233 The option ‘Service’ must be specified in the notification options identifier.
SQL Server Error Code – 21147 the ‘%s’ database is not published for m
In this blog post, you’ll learn more about the SQL Server Error Code 21147 and the error message description that is shown SQL Server Error Code 21147 SQL Server Error Description for the Code :21147 The ‘%s’ database is not published for merge replication.
SQL Server Error Code – 35313 the statement failed because specifying
In this blog post, you’ll learn more about the SQL Server Error Code 35313 and the error message description that is shown SQL Server Error Code 35313 SQL Server Error Description for the Code :35313 The statement failed because specifying FILESTREAM_ON is not allowed when creating a columnstore index. Consider creating a columnstore index on columns without filestream data and omit the FILESTREAM_ON specification.
SQL Server Error Code – 15063 the login already has an account under a
In this blog post, you’ll learn more about the SQL Server Error Code 15063 and the error message description that is shown SQL Server Error Code 15063 SQL Server Error Description for the Code :15063 The login already has an account under a different user name.
SQL Server Error Code – 21399 the transactions required for synchroniz
In this blog post, you’ll learn more about the SQL Server Error Code 21399 and the error message description that is shown SQL Server Error Code 21399 SQL Server Error Description for the Code :21399 The transactions required for synchronizing the subscription with the specified log sequence number (LSN) are unavailable at the Distributor. Specify a higher LSN.
SQL Server Error Code – 40651 failed to create server because the subs
In this blog post, you’ll learn more about the SQL Server Error Code 40651 and the error message description that is shown SQL Server Error Code 40651 SQL Server Error Description for the Code :40651 Failed to create server because the subscription ‘%.*ls’ is disabled.
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…