Re: rda push when owner is not dbo.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance



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: Full-Text Catalog does not build...
    ... John, thank you. ... from time to time during population I have got event about SQL ... Server machine has 6GB RAM, SQL Server uses AWE and has 5GB memory. ... dbo properties PK_properties 7 1 cat_neu_prop1 ...
    (microsoft.public.sqlserver.fulltext)
  • Re: web app for RDA pull
    ... I have a CE device with web server and SQL CE components installed. ... to do it also from a asp file using IIS. ... So what I think is that if the device has all components to do pull from VB ...
    (microsoft.public.sqlserver.ce)
  • Re: Using the ISA reporting from a sql database
    ... I tried to do a report from the reports tab in ISA, ... It comes up empty like it doesnt know where to pull the information from ... since I am logging to another server into sql. ...
    (microsoft.public.isa.configuration)
  • Failed to copy table objects - DTS Wizard
    ... one SQL 2000 database to another - both on the same ... I am using Enterprise Manager which is using SQL ... The name 'dbo' was not found in the ... sa is a member of Server Role "System Administrators" ...
    (microsoft.public.sqlserver.security)
  • Re: CE Emulator and RDA
    ... can you perhaps run SQL Profiler on the server to see which query ... > I am trying to make my first simple CE project that uses RDA. ... > 5) added a button to the form that executes the example pull code from CE ...
    (microsoft.public.dotnet.framework.compactframework)