SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA, SSMS and triggers

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA, SSMS and triggers
Author Message
Vitaliy



Joined: 13 May 2015
Posts: 8
Country: Ukraine

Post SA, SSMS and triggers Reply with quote
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 View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6485

Post Reply with quote
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 View user's profile Send private message
Vitaliy



Joined: 13 May 2015
Posts: 8
Country: Ukraine

Post Reply with quote
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 View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
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.