SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.1.261 Pro] - Only Columns shown in Database Explorer

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.1.261 Pro] - Only Columns shown in Database Explorer
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 1396

Post [SA 9.1.261 Pro] - Only Columns shown in Database Explorer Reply with quote
Only the Column property is shown in Database Explore, all the rest (keys, triggers, constraints, etc.) are missing (see screenshot).


Fri Mar 10, 2017 12:32 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I'm not able to reproduce this issue. Is that SQL Server? Which version?
Sat Mar 11, 2017 5:47 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1396

Post Reply with quote
Yes, it's SQL Server 2016 Developer Edition x64.
Sat Mar 11, 2017 8:17 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
I made a second attempt to reproduce it and failed again. May I ask you to take a look at at the "Table Objects (MSSQL)" query in the options. I believe you have previously customized it for default collations or something. If you run that query in the editor, doesn't it fail?
Tue Mar 14, 2017 8:20 am View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 1396

Post Reply with quote
You're right (reference post here). I seems that when upgrading to 9.1 that modified "Table Objects (MSSQL)" query was reverted to the default. I restored it from an earlier backup of my .sas file and now it works as expected. I guess that change to the db query did not make it into the factory defaults and it's still the old one getting in there when installing or upgrading and then it fails when it comes to expanding Database Explorer objects in a contained database.
Tue Mar 14, 2017 12:02 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6500

Post Reply with quote
The compatibility fix for contained databases hasn't been implemented yet.
Tue Mar 14, 2017 12:14 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.