view problem in analyser object browser

[aolb]

I have this view. When I select the view in the object browser in the query analyser I can’t see the columns.

When I try to open the view in the analyser it get an [Microsoft][ODBC SQL Server Driver][Timeout expired].

When I run the view as a query it works.

Any idea what’s going on and how to fix it?

 

[SQLBill]

First question: what edition and version of SQL Server are you using? (Edition: SQL Server 7, 2000, 2005, MSDE, etc) (Version: RTM, SP1, SP3a, SP4, etc).

Run:
SELECT ServerProperty('ProductEdition'),
ServerProperty('ProductLevel'),
ServerProperty('ProductVersion')

If you are running SQL Server 2000, you should have SP3a or SP4 installed.

-SQLBill

Posting advice: FAQ481-4875