In SQL server 2005 management studio, the Object Explorer has a Refresh
icon.  Plus, there's a Refresh item in the right-click menu if you click on
the Views folder icon in a database.

If you have a "Query" window open, and use that window to create a new
view, then you refresh the object explorer, the new view doesn't appear.

Why does the Refresh item exist if it doesn't do anything?

I have to disconnect and reconnect the server in order to get the new view
to show up.

I am connecting to a SQL 2000 database, if that makes a difference.  I'll
have to try while connected to a 2005 database.

Thanks.

David Walker

Sounds like a bug. I did a search on
http://connect.microsoft.com/feedback/default.aspx?SiteID=68 and didn't see
this was all ready entered. You should enter this in connect so it gets to
the product team @ Microsoft to look at.

Cheers,
Dan


Show quoteHide quote

David,

I couldn't reproduce this.  I opened a query editor window attached to
[pubs], then I typed this in the editor window:

CREATE VIEW dbo.newView as
SELECT  au_id, au_lname
FROM    authors
WHERE  (au_lname < 'L')

I then opened Views from Object Explorer, which correctly does
not show this view, since it doesn't exist yet.
I then executed this query to create the view, then right-clicked
on the Views folder I just opened, and the new view appeared.

Can you be more specific about the exact steps you took?

Steve Kass
Drew University

Show quoteHide quote

Show quote Hide quote Sure, Steve.  I have a question about what you said, but first, the steps I
did are this:

I opened a SQL 2000 database using SQL 2005 Management Studio.

In Object Explorer, I expand the databases, and expand the database I want,
and expand the views so that all views are shown.

I then click New Query on the toolbar.  In that query window, I type the
following:

Create View TestView as Select 50 As Fifty

I click Execute from the toolbar.  The messages pane says "Command(s)
completed successfully".

I then look in the Object Explorer window where the views are still
expanded, and I scroll up and down and see that TestView is not in the
list.

Question:  When you said you right-click on the View folder you jsut
opened, what do you mean?  I already have the views expanded in the Object
Browser window.  If I right-click on the Views icon in Object Explorer, I
get choices of New View, Filter, and Refresh.

Today, when I click Refresh, the views are indeed re-enumerated and
TestView does show up.  Last week, I swear this didn't happen.  So I think
I am OK with this now; it doesn't auto-refresh, but that's OK.

But I don't quite understand what Views folder you are talking about, or if
it's the same thing I am looking at.

David

Font in SQL pane in 2005
I need to extract .pdf/.doc/.xls documents from an sql 2000 table.
Copy Database Wizard - what would you improve?
Transact Log truncate
Edit/Modify Stored Procedure in Management Console 2005