 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
jrandall
Joined: 06 Oct 2008
Posts: 27
Country: United States |
|
 4.0 beta doesn't recognize MSSQL 2005 sys schema system view |
 |
Using SSMS. Type SELECT * from sys
or SELECT * from sys.
the popup selector only shows system views with names that begin with sys, rather than all views that are in the sys schema, like sys.tables, sys.procedures, etc. When I continue to type the table name (sys.tab), SQL Assistant doesn't attempt to complete the table name and the pop-up goes away. Continuing the SELECT statement, SQL Assistant won't pick up column names for these system views either.
|
|
| Fri Oct 10, 2008 12:11 pm |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
It works fine for me. Are you running 4.0.20 or 4.0.21?
|
|
| Fri Oct 10, 2008 1:19 pm |
|
|
jrandall
Joined: 06 Oct 2008
Posts: 27
Country: United States |
|
| |
|
4.0.20
|
|
| Fri Oct 10, 2008 1:24 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
Please update to 4.0.21. There were some functional changes in the database catalog queries.
|
|
| Fri Oct 10, 2008 1:26 pm |
|
|
jrandall
Joined: 06 Oct 2008
Posts: 27
Country: United States |
|
| |
|
ok. thanks. I was going to wait for the next release, hoping to avoid going thru the full download, re-register process
|
|
| Fri Oct 10, 2008 1:27 pm |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7847
|
|
| |
|
We are targeting next Monday for the new build
|
|
| Fri Oct 10, 2008 1:43 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
|
|
|
