When I try to import or export between my laptop and our SQL Server 2000
server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]
1;SQL
Server]Invalid object name 'dbo.vw_LaborTotalsAll'
I looked it up in technet and said it had something to do with the order of
dependent objects (e.g. tables) and that it could be resolved with SP3. I
have SP3 on both the laptop and server. The only difference is that the
laptop is the Developers Edition and the Server is Standard Edition.
Any ideas how to resolve/fix this error? Thanks.
DavidAssuming vw_LaborTotalsAll is a view. Who's the owner of it on both the
laptop and the server?
"David C" wrote:
> When I try to import or export between my laptop and our SQL Server 2000
> server I get 2 errors stating [Microsoft][ODBC SQL Server Driver]&
#91;SQL
> Server]Invalid object name 'dbo.vw_LaborTotalsAll'
> I looked it up in technet and said it had something to do with the order o
f
> dependent objects (e.g. tables) and that it could be resolved with SP3. I
> have SP3 on both the laptop and server. The only difference is that the
> laptop is the Developers Edition and the Server is Standard Edition.
> Any ideas how to resolve/fix this error? Thanks.
> David
>
>|||All objects have the same owner. Out of 100 views, only 2 are giving
this error.
David
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
No comments:
Post a Comment