Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server 2008 - The source database you have selected contains no visible tables or views

Posted on 2013-05-17
1
Medium Priority
?
2,816 Views
Last Modified: 2013-05-18
I'm trying to use the export wizard to export a table to excel.
But get the following message when I try to Select Source Table and Views.
any ideas

 The source database you have selected contains no visible tables or views
0
Comment
Question by:JElster
1 Comment
 
LVL 23

Accepted Solution

by:
Ioannis Paraskevopoulos earned 1600 total points
ID: 39176720
Hi,

Is it possible that you have logged in with a user that has no SELECT permisions in tables and views in this db? Try logging with a dbo.

Giannis
0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Loops Section Overview

877 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