SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SSMS 2014 intellisense bug      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SSMS 2014 intellisense bug Author Message Vitaliy Joined: 13 May 2015 Posts: 24 Country: Ukraine SSMS 2014 intellisense bug Hi Sql Assistant has this line in the DB Options -> DB Queries for different MSSQL queries Code: IF (@@version LIKE '%SQL Server 20%' AND @@version NOT LIKE '%2000%') Result of query SELECT @@VERSION: Microsoft SQL Server 2014 - 12.0.2000.8 (X64) As you see the second part of "IF" statement will be executed. That behavior leads to a lack of objects in intellisense popup. Fri May 06, 2016 6:24 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 This issue will be fixed in the next major version. for now, please replace all occurrences of "@@version NOT LIKE '%2000%'' with "@@version NOT LIKE '%SQL Server 2000%'" Fri May 06, 2016 9:55 am Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum     Powered by phpBB © 2001, 2005 phpBB Group Design by Freestyle XL / Flowers Online.