Re: rda push when owner is not dbo.

Here's a litle more info. I have verified that the account sqlserverce
usesuses (via IIs) is a member of dbo and has full access to the task table
(who's owner is privuser).

If I launch the sql query analyzewr (desktop version) and try to run the
following query

select * from task

I get the same invalid object task error that rda is returning.

However, if I run
select * from privuser.task

the query executes fine.

I'm pretty configdent that the owner name not being qualified is the
problem.


"mgarner1980" <mgarner@xxxxxxxx> wrote in message
news:uQ3hvJcRFHA.1096@xxxxxxxxxxxxxxxxxxxxxxx
> here's my deal. I have a database that has a table named task with owner
> privuser.
> I pull the table with rda to a local table named task.
>
> the table pulls ok and I can fully manipulat it locally.
>
> I try a push and it fails with the error below. (only if I have modified
the
> local data.....otherwise it throws no exception).
> I also created a test table in the same database with owner dbo and I
> canpush and pull it fine from the same code. That is what makes me think
> it's the owner that's throwing things off.
>
>
> when I try a push the local table "task" I get the error "cannot open
> table" "invalid object task"
>
> I'm at my wits end with this problem!
>
> I really don't understand the owner concept very well either. I'm sure
that
> 's one of my problems with this issue:(
>
>
> "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message
> news:enKjhY8OFHA.2604@xxxxxxxxxxxxxxxxxxxxxxx
> > what error are you getting? While I haven't tried pulling a table not
> > owned by DBO, my guess is that when you PULL with tracking on, and
> > then go to PUSH the table back to the server, as long as the account
> > that the SQL CE server tools are using to talk to SQL Server
> > is a member of the DBO group, you'll be ok.
> > --
> > Darren Shaffer
> > .NET Compact Framework MVP
> > Principal Architect
> > Connected Innovation
> > www.connectedinnovation.com
> >
> > "mgarner1980" <mgarner@xxxxxxxx> wrote in message
> > news:O96RBi7OFHA.1884@xxxxxxxxxxxxxxxxxxxxxxx
> > > I'm having trouble performing an RDA.Push on a table that has the
owner
> of
> > > privuser and not the default dbo.
> > >
> > > When I do the pull the sql has to specify privuser.tablename in order
> for
> > > the pull to work. Otherwise the error of table not found is thrown.
> > >
> > > How do I specify the owner.tablename for a rda push?
> > >
> > >
> >
> >
>
>


.

Relevant Pages

  • Re: rda push when owner is not dbo.
    ... that the SQL CE server tools are using to talk to SQL Server ... is a member of the DBO group, ... > When I do the pull the sql has to specify privuser.tablename in order for ...
    (microsoft.public.sqlserver.ce)
  • Re: rda push when owner is not dbo.
    ... I pull the table with rda to a local table named task. ... I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: db_owner role in SQL 2k
    ... Role membership doesn't affect the owner of an object. ... power to create objects owned by other users, including owned by dbo. ... SQL Server MVP ... "John" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • SQLCE Push pb on VB.Net Compact Framework
    ... I'm using RDA to sync the ce db with a sql server db. ... I have SQL Server tables with "dbo" owner and some have specific owner. ... The tables with owner "dbo" are sync with no pb - the pull and the push ...
    (microsoft.public.sqlserver.programming)
  • Re: User names
    ... a dbo or sa it will use dbo as the owner. ... Andrew J. Kelly SQL MVP "Laura K" wrote in message ... > The issue was resolved by installing SP3 for SQL server. ...
    (microsoft.public.sqlserver.server)