Re: null values in primary key

Well you could drop the constraint(s) that uses the PK, and then try
dropping the PK.

hth

Helen

"pascal.psion" <pascalpsion@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A25C7619-3BC5-4613-B975-F226CB39177A@xxxxxxxxxxxxxxxx
> Thank you a lot,
>
> I can't drop the pk ("the index cannot be removed because it is being used
> to enforce a contraint"), I ve compacted the database.
> I have a row filter and an agent resolver (subscriber always wins).
> I think I' ll try to copy the data to an another temporary table (without
> pk), but i am not sur that will be the good way.
> I have not another idea (I can't lose the data).
>
> pascal.
>
> "Darren Shaffer" wrote:
>
> > I've never seen that happen in 3+ years developing solutions
> > with SQL CE. If you cannot delete the rows, I'd try dropping
> > the PK, delete the rows and re-add the PK. You could also
> > try Compacting the database and try the above again. If that
> > doesn't work, you may need to delete the database and let merge
> > repl recreate the subscription for you. Before you do that, verify
> > your publication - do you have either a row filter in place or a
> > custom resolver that could be creating this situation?
> > --
> > Darren Shaffer
> > ..NET Compact Framework MVP
> > Principal Architect
> > Connected Innovation
> > www.connectedinnovation.com
> >
> > "pascal.psion" <pascalpsion@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> > news:2E0D716A-BD99-4A46-B38D-672349CE1592@xxxxxxxxxxxxxxxx
> > > Hello,
> > >
> > > I have a very strange problem :
> > >
> > > After a synchronisation with merge replication, my local database
(.sdf)
> > > has four lines where every field is null, with the primary key.
> > > In the device, i can't drop or delete the table.
> > >
> > > So, how can i do for deleted this fours records ?
> > >
> > > It 's impossbile to have a null value in a primary key, so it's very
> > > strange.
> > > Is it a bug of SQL Server, SQL CE ?
> > >
> > > Thank you,
> > >
> > > pascal
> >
> >
> >


.

Relevant Pages

  • Re: null values in primary key
    ... I ve compacted the database. ... I have a row filter and an agent resolver. ... > try Compacting the database and try the above again. ... >> Is it a bug of SQL Server, ...
    (microsoft.public.sqlserver.ce)
  • Re: Mail merge dropping records
    ... arrange those fields inside a single cell table that has the cell dimensions ... Doug Robbins - Word MVP ... > SSN, DOB, that I want to merge with a database of about ... > but did not solve dropping the others. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: [Info-ingres] Re: Unextend a database
    ... > necessary sanity check - ie the database in question isnt actually using ... But extenddb -l-drop isn't dropping an extent ... I'm gonna say it's not it's an unfortunate lack of a feature but it's not a bug. ...
    (comp.databases.ingres)
  • Re: Java problem
    ... Your solution of dropping the database and re-creating it would tend to ... other utilities (Query Analyser/osql) to verify what data is present in the ... version of MDAC and you SQL Server is on a recent service pack. ... > way I can fix this is by dropping the entire datrabase and recreating it. ...
    (microsoft.public.sqlserver.security)
  • Re: null values in primary key
    ... SQL CE database to flat files on device, drop and recreate ... > I have a row filter and an agent resolver. ...
    (microsoft.public.sqlserver.ce)