Re: View Columns do not show in Object Explorer
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 20 Feb 2007 23:27:55 +0000 (UTC)
Thom (Thom@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I have a view in SQL2000 that when I am in QA and drill down the columns
using the + signs no columns show in 2000. If I use SSMS and drill down
in the same way the columns do show.
Any body have a clue on this one? I have already dropped and recreated
the view. the db was restored from production and that is when it
started happening. I have the same issue on production.
It would have help a little to see the view definition...
It's a little confusing, because your subject line says that the column
does not show in Object Explorer, but in the text you say that they show
up in SSMS, and that's where Object Explorer lives.
Do you mean that the view columns do not show in the Object Browser in QA?
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Prev by Date: Re: SS2005 Mngmnt Studio - how to disable / "turn off" UNICODE??
- Next by Date: Re: SSMS: Event Notifications: Where are they?
- Previous by thread: Re: SS2005 Mngmnt Studio - how to disable / "turn off" UNICODE??
- Next by thread: Re: Error 0x80041010 WinMgmt when launching SQL SERVER MANAGEMENT STUD
- Index(es):
Relevant Pages
|
