Database Views in SQL Server

30 pts.
Tags:
Database Expert
SQL Server databases
Windows Server 2003
Windows XP
When I open database expert and open a new DB connection, only tables and stored procedures are shown. How do I get views to show? And yes, I did select views under options/database.

Software/Hardware used:
SQL Server, windows xp and server 2003

Answer Wiki

Thanks. We'll let you know when a new response is added.

I think I forgot to mention that I am trying to create a crystal report which pulls from three different views that I created in SQL Server. Little hard to do when I can not access the views from crystal reports/database expert.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • O0O0o
    I have the same issue with only one of my DBs and Crystal via ODBC. I can see the views with SSMS or Access but not Crystal. Please help.
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following