Category: SQL Server

SQL Server 2014 Tutorial – Personalize SQL Management Studio

Problem Statement You need to personalize SQL Server Management Studio. Solution There are various personalization options available for the SQL Server users in the SQL Management Studio. For example, if you want the Object explorer to be place on a different position instead of showing it in the left side of the SSMS, you can just move it by clicking it on the title bar…

SQL Server Error Code – 41195 availability group ‘%.*ls’ failed to pro

In this blog post, you’ll learn more about the SQL Server Error Code 41195 and the error message description that is shown SQL Server Error Code 41195 SQL Server Error Description for the Code :41195 Availability group ‘%.*ls’ failed to process the WSFC lease-renewal command. The local availability replica lease is no longer valid to process the lease renewal command. Availability replica lease expired. This…

SQL Server Error Code – 1959 cannot create an index on a view or comp

In this blog post, you’ll learn more about the SQL Server Error Code 1959 and the error message description that is shown SQL Server Error Code 1959 SQL Server Error Description for the Code :1959 Cannot create an index on a view or computed column because the compatibility level of this database is less than 80. Use sp_dbcmptlevel to raise the compatibility level of the…