Erro Mssage: tempdb is skipped. You cannot run a query that requires tempdb

While access a view (which is described as following), I encountered the
following error message:
tempdb is skipped. You cannot run a query that requires
tempdb
After I reboot the database, the error goes away.
What cauases this error, and how can I fix it?
Thanks.
-- Charlie Lu
=========================================== View:
SELECT USERTBL.name AS User_Name
,ROLETBL.name AS Role_Name
,RM.Is_Primary
FROM sysusers USERTBL
INNER JOIN sysmembers SM
ON USERTBL.uid = SM.memberuid
INNER JOIN sysusers ROLETBL
ON SM.groupuid = ROLETBL.uid
INNER JOIN ROLE_MAP RM
ON ROLETBL.name = RM.Role_NameI can't get that far to try and reproduce, because I get:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'ROLE_MAP'.
--
http://www.aspfaq.com/
(Reverse address to reply.)
"C. Ming Lu" <cminglu@.qmxs.com> wrote in message
news:eDVWJVdaEHA.556@.tk2msftngp13.phx.gbl...
> While access a view (which is described as following), I encountered the
> following error message:
> tempdb is skipped. You cannot run a query that requires
> tempdb
> After I reboot the database, the error goes away.
> What cauases this error, and how can I fix it?
> Thanks.
> -- Charlie Lu
> ===========================================> View:
> SELECT USERTBL.name AS User_Name
> ,ROLETBL.name AS Role_Name
> ,RM.Is_Primary
> FROM sysusers USERTBL
> INNER JOIN sysmembers SM
> ON USERTBL.uid = SM.memberuid
> INNER JOIN sysusers ROLETBL
> ON SM.groupuid = ROLETBL.uid
> INNER JOIN ROLE_MAP RM
> ON ROLETBL.name = RM.Role_Name
>|||Sorry about the , I cut it out of the view. Role_Map is the user defined
table.
Here is the selection statement.
SELECT USERTBL.name AS User_Name
,ROLETBL.name AS Role_Name
FROM sysusers USERTBL
INNER JOIN sysmembers SM
ON USERTBL.uid = SM.memberuid
INNER JOIN sysusers ROLETBL
ON SM.groupuid = ROLETBL.uid
Regards,
-- C. Ming Lu
"Aaron [SQL Server MVP]" <ten.xoc@.dnartreb.noraa> wrote in message
news:u$$GozdaEHA.2840@.TK2MSFTNGP11.phx.gbl...
> I can't get that far to try and reproduce, because I get:
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'ROLE_MAP'.
> --
> http://www.aspfaq.com/
> (Reverse address to reply.)
>
>
> "C. Ming Lu" <cminglu@.qmxs.com> wrote in message
> news:eDVWJVdaEHA.556@.tk2msftngp13.phx.gbl...
> > While access a view (which is described as following), I encountered the
> > following error message:
> > tempdb is skipped. You cannot run a query that requires
> > tempdb
> > After I reboot the database, the error goes away.
> >
> > What cauases this error, and how can I fix it?
> >
> > Thanks.
> >
> > -- Charlie Lu
> > ===========================================> > View:
> > SELECT USERTBL.name AS User_Name
> > ,ROLETBL.name AS Role_Name
> > ,RM.Is_Primary
> > FROM sysusers USERTBL
> > INNER JOIN sysmembers SM
> > ON USERTBL.uid = SM.memberuid
> > INNER JOIN sysusers ROLETBL
> > ON SM.groupuid = ROLETBL.uid
> > INNER JOIN ROLE_MAP RM
> > ON ROLETBL.name = RM.Role_Name
> >
> >
>