<div>
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.
</div>


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.

<div>
Thanks for responding, but I'm logged in as domain administrator, who is DBO.
</div>


Thanks for responding, but I'm logged in as domain administrator, who is DBO.

<div>
SQL restart fixed it... last resort.
</div>


<div>
Glad you found that. Very odd. 
</div>


<div>
<div class="content wysiwyg-content">
I have an ASP.NET website using the ASP database running on SQL Server 2008 R2.<br />
I'm trying to write a query against this database with the queryu designer, but when select 'add table' theres no tables available. &nbsp;Any ideas?<br />
<br />
See image attached... <a href="https://filedb.experts-exchange.com/incoming/2011/10_w44/517420/asp.jpg" target="_blank" title="View of designer (63 KB)"><img alt="View of designer" class="file-block lazyload" style="max-width: 800px;" data-src="https://filedb.experts-exchange.com/incoming/2011/10_w44/800_517420/asp.jpg" /></a>
</div>
</div>


asp.jpg

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... 

SQL Query designer add table window is blank - ASP DB

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications