Data provider or other service returned an E_Fail status

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
 NU
LL ,
& #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_C
I_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 [Subu
rbID],
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.