Indexed views in SQL Server 2014 object explorer without index node
sql-server-2014, ssms
Solution
This has been fixed in Cumulative Update 5, check here and download from Microsoft site: https://support.microsoft.com/en-us/kb/3014193
Problem
In the SQL Server 2014 Management Studio's object explorer indexed views with schemabinding don't have an index node. Thus, you can create and drop Indexes for views only via T-SQL. The SQL Server Management Studio 2012 still shows the index node. Has anybody experienced the same or is there some Management Studio setting in version 12.0.2000.8 which I am missing? Many thanks in advance. Marcus