SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in [11.2.246 Pro] - BUG: reserved word picked as alias (SSMS)      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic [11.2.246 Pro] - BUG: reserved word picked as alias (SSMS) Author Message gemisigo Joined: 11 Mar 2010 Posts: 2108 [11.2.246 Pro] - BUG: reserved word picked as alias (SSMS) I have a table named indexoptimize_settings. When I choose that table from a popup triggered by SELECT in the SQL Editor, its alias is set to is1. When I do the same in SQL Server Management Studio, the alias will be the reserved word is. SQL Server Management Studio info Quote: SQL Server Management Studio 15.0.18338.0 SQL Server Management Objects (SMO) 16.100.41011.9 Microsoft Analysis Services Client Tools 15.0.19205.0 Microsoft Data Access Components (MDAC) 10.0.19041.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.19041 Wed Sep 09, 2020 5:31 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7847 I failed to reproduce the same result in two different SQL Server versions using two different versions of SSMS. Are you entering the usual SELECT * FROM table or something else different? Are you sure the alias is inserted by SA and not by SSMS intellisense if it's enabled? Wed Sep 09, 2020 10:59 pm 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.