• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 865
  • Last Modified:

SQL Query designer add table window is blank - ASP DB

I have an ASP.NET website using the ASP database running on SQL Server 2008 R2.
I'm trying to write a query against this database with the queryu designer, but when select 'add table' theres no tables available.  Any ideas?

See image attached... View of designer
0
jamie77777
Asked:
jamie77777
  • 3
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
That may be an indication that the user id you are connecting with has permissions to SELECT, but not REFERENCES. Try adding that privilege or using another more privileged account and see what happens.
0
 
jamie77777Author Commented:
Thanks for responding, but I'm logged in as domain administrator, who is DBO.
0
 
jamie77777Author Commented:
SQL restart fixed it... last resort.
0
 
jamie77777Author Commented:
SQL restart fixed it... last resort.
0
 
Kevin CrossChief Technology OfficerCommented:
Glad you found that. Very odd.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now