Category: SQL Server

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 – 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 – 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 – 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 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…