SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SET IDENTITY_INSERT is getting quoted identifiers on command      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SET IDENTITY_INSERT is getting quoted identifiers on command Author Message judahr Joined: 09 Mar 2007 Posts: 319 Country: United States SET IDENTITY_INSERT is getting quoted identifiers on command v3.0.28 Type the following SET I<ENTER> you will get SET [IDENTITY_INSERT] which is not valid. "Always Add Delimeters" is set to none. Tue Dec 11, 2007 12:12 pm SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 This is a bug. SQL Assistant attempts to wrap in brackets all keywords used for object/column names. SET is not an applicable case for that. To fix it on your end, you can remove SET commands from the Intellisense options - remove them from the Custom Assistance edit box in the "SQL Assistant" option group; or create a snippet to have the entire line inserted automatically, for example, name it sii and then use sii<CTRL><ENTER> to insert the text into the code. Tue Dec 11, 2007 2:21 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.