Category: SQL Server

SQL Server 2014 Tutorial – Display System Databases in Object Explorer.

Problem Statement You need to view the System Databases in Object Explorer. Solution By default , there are few System databases that gets created when you install SQL Server. Some of these databases are master – This is the primary system database which is needed for the SQL Server to start and work fine. It contains the information about databases , logins , configurations etc….

SQL Server Error Code – 22925 the number of columns captured by captur

In this blog post, you’ll learn more about the SQL Server Error Code 22925 and the error message description that is shown SQL Server Error Code 22925 SQL Server Error Description for the Code :22925 The number of columns captured by capture instance ‘%s’ exceeds the maximum allowed number: %d. Use the @captured_columns_list parameter to specify a subset of the columns less than or equal…