Server Explorer shows only tables,views & stored procedures. Why?

[xramaas]

I'm wondering why Server Explorer, when I browse my SQL Server (Enterprise Version), shows only tables, views & stored procedures. In Desktop Engine, everything is present - i.e. diagrams & functions. What is the reason for this? My VB .NET is Pro Version.

 

[mattyboy2000]

I can't answer your question, but I would like to ask you a question. Can you create tables and stored procedures through VB.NET?

We can't, but can't understand why. Were currently using SQL serve it's self. Also I have seen an example of how to debug a SQL stored procedure through .NET, but as we can't access the code via .NET we can't do that

Any suggestions are welcomed

Ta

Matt

 

[xramaas]

I guess your problem lies in the fact that the version of Visual Studio you have is probably Professional. My guess is that, I can' t be 100% sure, the creating & erasing procedures and tables is a feature of Enterprise Arhitect, not sure.
But SQL debugging is surely a EA feature, so think of upgrade. By the way, do you see diagrams or stored procedures when you explore SQL server from VS .NET?
Did you installed any Service Packs for SQL Server?
Ever received a message "ADO cannot resolve collation error ..."? Damn, this problems are a drag.