| Offal Eater 2005-07-28, 3:23 am |
| Hi,
I'm getting this error message all of a sudden when trying to return rows
from one of my tables.
"Data provider or other service returned an E_Fail status"
This table has normally worked fine, it contains about five thousand rows.
The error seems to be random, most of the time I can still pull data back
from this table, but every now and then I get this error, and only on this
one table.
It seems to be a pretty generic sort of error, I'm pretty lost as to what
the problem is.
Here's a copy of the table...
--------------------------------
CREATE TABLE [dbo].& #91;tbl_SaySo_Restau
rants] (
[RestaurantID] [int] IDENTITY (1, 1) NOT NULL ,
& #91;RestaurantActive
] [tinyint] NULL ,
[RestaurantName] [nvarchar] (100) COLLATE SQL_Latin1_General_C
P1_CI_AS NOT
NULL ,
& #91;RestaurantImage]
[nvarchar] (100) COLLATE SQL_Latin1_General_C
P1_CI_AS
NULL ,
& #91;RestaurantDescri
ption] [nvarchar] (150) COLLATE
SQL_Latin1_General_C
P1_CI_AS NULL ,
& #91;RestaurantPhone]
[nvarchar] (50) COLLATE SQL_Latin1_General_C
P1_CI_AS NULL
,
& #91;RestaurantWebsit
e] [nvarchar] (100) COLLATE Latin1_General_CI_AS
NULL ,
& #91;RestaurantStreet
Address] [nvarchar] (150) COLLATE
SQL_Latin1_General_C
P1_CI_AS NULL ,
[SuburbID] [int] NOT NULL ,
[CityID] [int] NOT NULL ,
& #91;ShoppingCentreID
] [smallint] NOT NULL ,
[BookingID] [smallint] NULL ,
& #91;AvgPriceMainMeal
] [money] NOT NULL ,
[RegularSpecial] [nvarchar] (50) COLLATE Latin1_General_CI_AS
NULL ,
& #91;IntroductoryOffe
r] [nvarchar] (50) COLLATE SQL_Latin1_General_C
P1_CI_AS
NULL ,
& #91;IntroductoryOffe
rConditions] [nvarchar] (70) COLLATE
SQL_Latin1_General_C
P1_CI_AS NULL ,
[FeedbackOffer] [nvarchar] (50) COLLATE Latin1_General_CI_AS
NULL ,
& #91;FeedbackOfferCon
ditions] [nvarchar] (70) COLLATE Latin1_General_CI_AS
NULL
,
[RestaurantMenu] [ntext] COLLATE SQL_Latin1_General_C
P1_CI_AS NULL ,
& #91;RestaurantLogin]
[nvarchar] (50) COLLATE SQL_Latin1_General_C
P1_CI_AS NULL
,
& #91;RestaurantPasswo
rd] [nvarchar] (50) COLLATE SQL_Latin1_General_C
P1_CI_AS
NULL ,
[MembershipID] [tinyint] NOT NULL ,
[RankID] [tinyint] NOT NULL ,
[UserID] [int] NULL ,
[RestaurantHits] [int] NOT NULL ,
& #91;RestaurantDateAd
ded] [datetime] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].& #91;tbl_SaySo_Restau
rants] ADD
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_Backup_Rest
aurantActive] DEFAULT (0)
FOR & #91;RestaurantActive
],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_SuburbID] DEFAULT (1) FOR [SuburbID],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_CityID] DEFAULT (1) FOR [CityID],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_ShoppingCen
treID] DEFAULT (1) FOR
& #91;ShoppingCentreID
],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_AvgPriceMai
nMeal] DEFAULT (0) FOR
& #91;AvgPriceMainMeal
],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_MembershipI
D] DEFAULT (1) FOR
[MembershipID],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_RankID] DEFAULT (1) FOR [RankID],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_Restuarants
Hits] DEFAULT (1) FOR
& #91;RestaurantHits],
CONSTRAINT & #91;DF_tbl_SaySo_Res
taurants_Backup_Rest
aurantDateAdded] DEFAULT
(getdate()) FOR & #91;RestaurantDateAd
ded],
CONSTRAINT & #91;PK_tbl_SaySo_Res
taurants_Backup] PRIMARY KEY CLUSTERED
(
[RestaurantID]
) ON [PRIMARY]
GO
--------------------------------
If anyone could provide some help here, would be great.
Offal Eater.
|