|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
View Columns do not show in Object ExplorerI 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. Thom (T***@discussions.microsoft.com) writes:
> I have a view in SQL2000 that when I am in QA and drill down the columns It would have help a little to see the view definition...> 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'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, esq***@sommarskog.se 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 yes that is correct, no in object broswer of QA in SQL2000,
I'll post the def later... have to jump through some hoops to get to the client  |
|||||||||||||||||||||||
Other interesting topics