Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-09-03 : 20:38:50
|
| Jean writes "Hello SQLTeam,I need your expertise to help me resolve the problem I encoutered with MSSQL7 (The SQL Server is hosted in Windows NT system - WinNT 4.0 Enterprise Edition with SP6).I was using SQL Analayzer to query a certain table (let's call it PTABLE) and it puzzled me why was it taking more than a handful of seconds to complete my query (SELECT * FROM PTABLE) considering that the size of PTABLE is 320K. The Analyzer returns only an approx of 500 rows and then I have to cancel the query to give way to other processes that is being locked out by my query.And so, I switched to the SQL Manager just in case the problem is with the Analyzer. When I selected the task to return all rows from PTABLE, about 500 of rows were returned and with the rest, the manager stalls (cursor is busy) for several seconds and the error "The data provider or other service returned an E_FAIL status" comes out.I searched the Microsoft site to check the error but the knowledge base returns results which seem to have no relation to my problem at all.I did web search, I have found the link below that may seem to be an explanation to my problem though I cannot verify it and the way to resolve the problem is still unknown to me.http://www.tinker-tech.com/?Info=?App_Module=SUPPORT&ID=117PTABLE STRUCTUREPTABLE {field1 varchar(10) null not allowed PRIMARY KEYfield2 varchar(50) null allowed field3 char(1) null allowed DEFAULT (0)field4 varchar(50) null allowed field5 varchar(50) null allowed field6 varchar(100) null allowed field7 varchar(100) null allowed field8 varchar(20) null allowed field9 varchar(20) null allowed field10 varchar(20) null allowed field11 varchar(100) null allowed field12 varchar(50) null allowed field13 char(1) null allowed DEFAULT 'u' field14 varchar(50) null allowed field15 varchar(20) null allowed field16 varchar(20) null allowed field17 varchar(20) null allowed field18 datetime(8) null allowed DEFAULT (getdate())}" |
|
|
|
|
|
E_FAIL status during a table query