SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in SA, SSMS and triggers      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic SA, SSMS and triggers Author Message Vitaliy Joined: 13 May 2015 Posts: 24 Country: Ukraine SA, SSMS and triggers Hi. I've checked the "Triggers" checkbox in DB Options -> Sql Assistance -> SQL Server -> List Items. But I can't get table's list of triggers in suggestion. Fri May 06, 2016 7:05 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 This might be related to the previous issue. Please check "Objects (MSSQL) + Typed Synonyms" query if it has "@@version not like '%2000%'" sub-string. If yes, please fix it as described in the previous issue. Fri May 06, 2016 10:02 am Vitaliy Joined: 13 May 2015 Posts: 24 Country: Ukraine Yes, I know. I fixed all queries for MSSQL before that. But for triggers this didn't help. The result set of query "Objects (MSSQL) + Typed Synonyms" has all triggers in schema. If I understand correctly [$DB_NAME$] might be replaced with database name and :SCHEMA_ID with SHEMA_ID('dbo') for example. Fri May 06, 2016 4:08 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.