Re: Unable to merge replication table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks for your quick answer.

This table never had more than 255 fields, in fact, it has never been bigger
than it is right now.
I can't post the error message because there isn't one.
The only thing I get is a HRESULT of 0x80004005 and native error of 0.
According to Hilary Cotter, this is the generic access denied error message.

I've checked persmission/authorization and nothing seems wrong to me.
The other tables from that database replicate just fine in the same
publication as long as this table isn't part of it.

"Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx> a écrit dans le message de news:
OpCe%23qUFGHA.344@xxxxxxxxxxxxxxxxxxxxxxx
> Jonathan,
> works fine for me. Are you perhaps using a table that previously had a lot
> of columns (>255) and subsequently had some columns deleted? If so you
> could be running into the issue from a thread last week ("Problem with
> tables where the Column_id > 255"). BTW please could you post up the error
> message if this is not the issue.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>


.

Relevant Pages

  • Re: Connecting to a sql server database
    ... You are trying to use integrated security in your app (as is shown in the ... line numbered code where the connection string is shown). ... sql server, hence integrated security fails. ... > causing the error message and what the correction for this. ...
    (microsoft.public.dotnet.general)
  • Re: Invalid OLEVERB structure error 80040000 on DTS job
    ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >- I copied this DTS package from a 32 bit Windows Server 2003 system. ... >I would only get that error message in the Job History logs though. ...
    (microsoft.public.sqlserver.dts)
  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
    (microsoft.public.security)
  • Re: ANNOUNCEMENT: New SQL Server security tool - SQL Server 2000 Scan Tool
    ... > This posting is provided "AS IS" with no warranties, and confers no rights. ... >> computers running Windows 2000 or higher and can identify instances ... >> please state the version of SQL Server being used and the error ... >> error message text received, ...
    (microsoft.public.windowsxp.security_admin)