Solved

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

Posted on 2013-05-17
1
2,376 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 400 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
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 Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

867 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

15 Experts available now in Live!

Get 1:1 Help Now