I am trying to opoen a view from Enterprise Mgr to display all rows,
but I am getting the following error:
[Microdoft][ODBC SQL Server Driver]Timeout expired
I can run the query against small amount of data. But gives the above
error with bigger tables.
I can however run the query on big tables from Query Analyzer without
Online book asks me to go to Tools-Options and set the SQL Query
timeout value as below:
"To increase the SQL Query Time-out value
From the Tools menu, choose Options.
In the left pane, click Data Tools, and then click Data View.
Type a new value in the SQL query time-out box."
But I cannot see any Data Tools button.
I am running Sql Server 7.
Any help is greately appreciated