Solved

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

Posted on 2013-12-13
12
277 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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
 

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 69

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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Stored procedure 4 36
How can i use WITH CTE for checking exist value? 3 55
Replication failure 1 20
SSMS Imprt data from Excel 7 20
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

762 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