Re: rda push when owner is not dbo.
- From: "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 7 Apr 2005 17:04:12 -0600
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?
>
>
.
- Follow-Ups:
- Re: rda push when owner is not dbo.
- From: mgarner1980
- Re: rda push when owner is not dbo.
- References:
- rda push when owner is not dbo.
- From: mgarner1980
- rda push when owner is not dbo.
- Prev by Date: rda push when owner is not dbo.
- Next by Date: Re: problem for PPC connecting SQL Server2000
- Previous by thread: rda push when owner is not dbo.
- Next by thread: Re: rda push when owner is not dbo.
- Index(es):
Relevant Pages
|