Timeout Expired, while in EM, opening a view

[kim]

I get a 'Timeout Expired' while in Enterprise Manager, trying to open a view...if I choose the top 1000..it opens fine.
My setting on the server has the default of '600'...what can I do to fix this problem ?
Put indexes/primary keys on the view ?

thank you

[MAK]

Why cant you use SQL Query analyzer?

[kim]

I could, but was just wondering why its timing out now..when it used to work...Im assuming its getting too big
Is there a way to set indexes/primary keys on a view ?

[MAK]

your assumption might be right.

to create index on a view- check BOL


example from BOL

CREATE VIEW V1
WITH SCHEMABINDING
AS
SELECT SUM(UnitPrice*Quantity*(1.00-Discount)) AS Revenue, OrderDate, ProductID, COUNT_BIG(*) AS COUNT
FROM dbo.[Order Details] od, dbo.Orders o
WHERE od.OrderID=o.OrderID
GROUP BY OrderDate, ProductID

[rmiao]

I read somewhere that em has hard coded 30 seconds timeout period.

[kim]

that you cannot edit ?

thank you

[MAK]

In EM

Tools-option-advanced- querytimeout

[kim]

that's set to '0', which I assume is unlimited

[MAK]

Yes

[MAK]

I found where Ray read this.....

http://support.microsoft.com/default...NoWebContent=1

[MAK]

You can do the following

1. Use QueryAnalyser or
2. ISQL or
3. OSQL or
4. BCP out and read the file in notepad or
5. use thirdparty tool like infomaker or
6. create web browser and see that in a data grid or

[kim]

great, this article http://support.microsoft.com/defaul...&NoWebContent=1 describes why....thank you

[MAK]

Dead Link