Category: SQL Server

SQL Server 2014 Tutorial – SQL Server Management Studio

Problem Statement You need to manage your Microsoft SQL Server environment using SSMS (SQL Server Management Studio). Solution Microsoft SQL Server Management Studio (SSMS) lets the administrators to perform the following Configure SQL Server components. Create Database, tables, stored procedures and views. Manage data inside the database. and more… Follow the below steps to manage your SQL Server environment in Microsoft SQL Server Management Studio…

SQL Server Error Code – 9767 the security certificate bound to databa

In this blog post, you’ll learn more about the SQL Server Error Code 9767 and the error message description that is shown SQL Server Error Code 9767 SQL Server Error Description for the Code :9767 The security certificate bound to database principal (Id: %i) has been disabled for use with BEGIN DIALOG. See the Books Online topics “Certificates and Service Broker” for an overview and…

SQL Server Error Code – 10132 cannot create %s_msg on view “%.*ls” bec

In this blog post, you’ll learn more about the SQL Server Error Code 10132 and the error message description that is shown SQL Server Error Code 10132 SQL Server Error Description for the Code :10132 Cannot create %S_MSG on view “%.*ls” because it references table valued common language runtime (CLR) function “%.*ls”. Consider removing reference to the function or not indexing the view.

SQL Server Error Code – 12120 accelerated database recovery cannot be

In this blog post, you’ll learn more about the SQL Server Error Code 12120 and the error message description that is shown SQL Server Error Code 12120 SQL Server Error Description for the Code :12120 Accelerated Database Recovery cannot be enabled until the Persistent Version Store is cleaned of previous versions. Please use the procedure sys.sp_persistent_version_cleanup ‘%.*ls’ to clean the Persistent Version Store.

SQL Server Error Code – 7358 cannot execute the query. the ole db pro

In this blog post, you’ll learn more about the SQL Server Error Code 7358 and the error message description that is shown SQL Server Error Code 7358 SQL Server Error Description for the Code :7358 Cannot execute the query. The OLE DB provider “%ls” for linked server “%ls” did not provide an appropriate interface to access the text, ntext, or image column “%ls.%ls”.

SQL Server Error Code – 21356 warning: only subscribers running sql se

In this blog post, you’ll learn more about the SQL Server Error Code 21356 and the error message description that is shown SQL Server Error Code 21356 SQL Server Error Description for the Code :21356 Warning: only Subscribers running SQL Server 7.0 Service Pack 2 or later can synchronize with publication ‘%s’ because publication wide validation task is performed.