No, the user was complaining that they could not script...I told them they had the rights to...

Thanks guys..

I got it...thanks guys

THANKS GUYS I GOT

THANKS TO YOU GUYS!!!

GOOD KARMA!!! 2 YOU ALL!!!!

Same error

Msg 7314, Level 16, State 1, Line 1

The OLE DB provider "SQLNCLI" for linked server "VSMIADBGP01" does not contain the table ""LPB_GreatPlainsUtils"."dbo"."vwADB_LPB_CONSOLIDATED_ACCOUNT_DIV_DEPT_BRANCH_YEAR_2009"". The table either does not exist or...

the view does exist...

how can I go about checking the permission?

thanks guys

when I run it I get -

The OLE DB provider "SQLNCLI" for linked server "VSMIADBGP01" does not contain the table ""LPB_GreatPlainsUtils"."dbo"."vwADB_LPB_CONSOLIDATED_ACCOUNT_DIV_DEPT_BRANCH_YEAR_2009"". The table either does not exist or...

what setting in local setting in local security policy?

Can you elaborate?

I looked for my user and didn't see him?

K thanks..

in the event log it says

"The SQL Server Reporting Services (MSSQLSERVER_SSRS) service failed to start due to the following error:

The system cannot find the path specified.

got it thanks anyhow..

K, so either or works....whew!!

Thanks Man!!

Figured it out..thanks anyhow guys

Cool, thanks everyone.

Yep they are pretty small..and it's okay to take them all off line.

So it would be better to dettach the MDF/LDF's then it would be to create BAK files?

Is there...

Yes he did and I'm grateful.

My verbage was entirly incorrect. I apologize, rough weekend.

Using his method the proc is reeeeally slow, is ther another way to write the same thing...