 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [SA 9.1.261 Pro] - Only Columns shown in Database Explorer |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
I'm not able to reproduce this issue. Is that SQL Server? Which version?
|
|
| Sat Mar 11, 2017 5:47 pm |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Yes, it's SQL Server 2016 Developer Edition x64.
|
|
| Sat Mar 11, 2017 8:17 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
The compatibility fix for contained databases hasn't been implemented yet.
|
|
| Tue Mar 14, 2017 12:14 pm |
|
|
|
|
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
|
|
|
