Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-05-18 : 08:23:43
|
| Wim writes "Hi,Something strange has happened to some of our developement databases. When using the design viewer to build views, none of the columns are displayed. The only option available is '* (All Columns)'. The design viewer does however show the columns on other databases. I checked column and table permissions, and all is fine. The databases were created using the sa login and the dbo user is assigned the public and db_owner roles and can select, update, and delete from these tables.Have you seen this before?Please advice. Thanks in advance." |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-05-18 : 08:50:13
|
| Is there a case statement or similar on the view as the design window doesn't support a lot of SQL...If you just double click the view, you will be able to see the SQL.. |
 |
|
|
wctz
Starting Member
1 Post |
Posted - 2004-05-18 : 09:48:02
|
Hi all,I posted this message originaly. The problem exist with a "." notation in the database name. I found this on the internet: [url]http://64.233.161.104/search?q=cache:WUFftPmPwooJ:dbforums.com/arch/72/2003/10/893650+%22sql+server%22+%2B%22*+(All+Columns)%22+%2Bmissing++%2Bdesigner&hl=en&start=4[/url]hope this helps  |
|
|
|
ravilobo
Master Smack Fu Yak Hacker
1184 Posts |
Posted - 2004-05-19 : 02:55:42
|
| Really nice article. Informative. Thanks------------------------I think, therefore I am |
|
|
|
|
|
|
columns missing in the view designer