Printable View
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
Why cant you use SQL Query analyzer?
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 ?
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
I read somewhere that em has hard coded 30 seconds timeout period.
that you cannot edit ?
thank you
In EM
Tools-option-advanced- querytimeout
that's set to '0', which I assume is unlimited
Yes
I found where Ray read this.....
http://support.microsoft.com/default...NoWebContent=1
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
great, this article http://support.microsoft.com/defaul...&NoWebContent=1 describes why....thank you
Dead Link