Solved

SQL Server 2008 R2 - How to refresh

Posted on 2014-04-22
2
487 Views
Last Modified: 2014-04-22
Hi and thinks,

I am very new to all this and this maybe a very simple question...


Everytime I:
Create a Table
Create a View
Create a Stored Procedure

I do not see anything I created.
So I close the SQL Server 2008 R2
and then I can see the created items

I have tried:
F5
Ctrl>Shift>R
but this did nothing...

Do I have to close and restart SQL Server?
How do I see the newly created items without having to close and restart???

Thanks...
0
Comment
Question by:Amour22015
2 Comments
 
LVL 6

Accepted Solution

by:
Dulton earned 250 total points
ID: 40014717
go to the 'layer' above where you've created an item (i.e. if you create a table, go to "tables", a view, go to "views"),,, right-click on the folder and select refresh.
0
 

Author Closing Comment

by:Amour22015
ID: 40014725
Thanks, I just found that and was going to delete the post but you were quick...
0

Featured Post

MIM Survival Guide for Service Desk Managers

Major incidents can send mastered service desk processes into disorder. Systems and tools produce the data needed to resolve these incidents, but your challenge is getting that information to the right people fast. Check out the Survival Guide and begin bringing order to chaos.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I'm trying, I really am. But I've seen so many wrong approaches involving date(time) boundaries I despair about my inability to explain it. I've seen quite a few recently that define a non-leap year as 364 days, or 366 days and the list goes on. …
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question