Solved

Can not see a table in management studio but can update it

Posted on 2013-12-13
12
273 Views
Last Modified: 2013-12-17
I can not see the table in the table list in Management Studio but I can select and update data in it. What could be the problem?
0
Comment
Question by:dwiseman3
12 Comments
 
LVL 15

Expert Comment

by:Ess Kay
ID: 39717255
permissions?

Or wrong server

Or wrong login



How about a screenshot
0
 
LVL 65

Assisted Solution

by:Jim Horn
Jim Horn earned 100 total points
ID: 39717283
<... adding onto the fun ...>
Are you certain?  Is it a table, view, or table valued function?  
Does it have a schema other than dbo, which means it sorts schema first, then object name?
0
 

Author Comment

by:dwiseman3
ID: 39717306
Hope you can see that the table does not appear.
If I link to the tables via ODBC I can select the zsubject table but I can not update it.
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39717323
>Hope you can see that the table does not appear.
Uhh, no.
We don't have access to your SSMS, and esskayb2d asked you for a screen shot that hasn't been provided yet.
Experienced experts here know not to assume things.
0
 

Author Comment

by:dwiseman3
ID: 39717356
here is the file. I thought it attached in my last post.
zsubject.docx
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39717363
In your screenshot, scroll up to make sure that the table list is inside the database named 'Sandbox', as that's what is displayed in the database combo box in the toolbar.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 

Author Comment

by:dwiseman3
ID: 39717415
The table list I showed is under Sandbox.
We have several databases, all historical snapshots of the production database.
Zsubject does not appear in any of them except the original database GwenSandbox.
See the attached screenshot.
zsubject-GS-database.docx
0
 
LVL 65

Expert Comment

by:Jim Horn
ID: 39717487
>Zsubject does not appear in any of them except the original database GwenSandbox.
In your first screen shot the database combo box showed Sandbox, which means the UPDATE query executes against Sandbox.  So, if zsubject doesn't appear in Sandbox, executing the statement would return an error.

Just for kicks and giggles, try these
update sandbox..zsubject
set descript = 'World Language'
where subjectc = 'L'

update GwenSandbox..zsubject
set descript = 'World Language'
where subjectc = 'L'

Open in new window


Also, if the table was added recently, to view it you'll have to go to Tables and do a right-click:Refresh.

I'm not aware of a .Visible property to a table.
0
 

Author Comment

by:dwiseman3
ID: 39717517
I executed the update statement against the database where the table does not appear in the list. I can't update Gwensandbox. It is a historical record.
I know how to refresh the list.
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 39717548
Maybe it's a synonym, pointing into another DB?
0
 
LVL 38

Accepted Solution

by:
Jim P. earned 400 total points
ID: 39719302
How are you logged in? Are you using the SA account with SQL auth or windows authentication.

Is there a folder under the tables view is the a %userid% schema?

Do a
SELECT *
FROM sys.objects
WHERE [Name] LIKE '%subject%'

Open in new window

0
 

Author Closing Comment

by:dwiseman3
ID: 39725153
The select from sys.objects identified the object as a view not a table.
I was so sure it was a table because it had been one in our original database.
Someone changed the object type to a view...
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

932 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now