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: 7955
|
|
|
|
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: 7955
|
|
|
|
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: 7955
|
|
|
|
We are targeting next Monday for the new build
|
|
Fri Oct 10, 2008 1:43 pm |
|
 |
|