Cannot remove replication

I don't have a SQL 7.0 box at work anymore, but if it
also exists on SQL 7.0, please try using
sp_MSunmarkreplinfo which takes a tablename as a parameter
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]Before updatnig system tables, I would recommend making sure you've dropped
the distributor and publisher. In EM from Tools...Replication...configure
publishing subscribers and distributors. Make sure there are no selections
(uncheck all boxes).
Colleen
"Paul Ibison" wrote:

> I don't have a SQL 7.0 box at work anymore, but if it
> also exists on SQL 7.0, please try using
> sp_MSunmarkreplinfo which takes a tablename as a parameter
> HTH,
> Paul Ibison (SQL Server MVP)
>
>
>

Cannot remove replication

I don't have a SQL 7.0 box at work anymore, but if it
also exists on SQL 7.0, please try using
sp_MSunmarkreplinfo which takes a tablename as a parameter
HTH,
Paul Ibison (SQL Server MVP)
[vbcol=seagreen]
Before updatnig system tables, I would recommend making sure you've dropped
the distributor and publisher. In EM from Tools...Replication...configure
publishing subscribers and distributors. Make sure there are no selections
(uncheck all boxes).
Colleen
"Paul Ibison" wrote:

> I don't have a SQL 7.0 box at work anymore, but if it
> also exists on SQL 7.0, please try using
> sp_MSunmarkreplinfo which takes a tablename as a parameter
> HTH,
> Paul Ibison (SQL Server MVP)
>
>
sql

cannot load dll xpstar.dll reason 126

Hi
This error message happens when trying to restore/backup a database
(The file exists in the binn directory)
How do I solve it ?
thanks in advance
RomyIs the full error message:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
<romyedevelop@.hotmail.com> wrote:
>Hi
>This error message happens when trying to restore/backup a database
>(The file exists in the binn directory)
>How do I solve it ?
>thanks in advance
>Romy
>|||Are you using the Database Maintenance Wizard to do your backups by any
change?
Than you should also check the dependencies of SQLMAINT.EXE which gets
called via XPSTAR.DLL xp_sqlmaint
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright © SQLDev.Net 1991-2004 All rights reserved.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2mau0plboskh42tcqhfeoovn48rngicnt@.4ax.com...
> Is the full error message:
> Cannot load the DLL xp_star.dll, or one of the DLLs it
> references.
> Reason: 126(The specified module could not be found.).
> If so, you are likely missing one of the files that
> xp_star.dll has a reference to. You can use a dependency
> tool like Dependency Walker (Depends.exe) to list all the
> dependency for xp_star.dll and narrow down which of the
> files is missing.
> -Sue
> On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
> <romyedevelop@.hotmail.com> wrote:
>>Hi
>>This error message happens when trying to restore/backup a database
>>(The file exists in the binn directory)
>>How do I solve it ?
>>thanks in advance
>>Romy
>

cannot load dll xpstar.dll reason 126

Hi
This error message happens when trying to restore/backup a database
(The file exists in the binn directory)
How do I solve it ?
thanks in advance
Romy
Is the full error message:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
<romyedevelop@.hotmail.com> wrote:

>Hi
>This error message happens when trying to restore/backup a database
>(The file exists in the binn directory)
>How do I solve it ?
>thanks in advance
>Romy
>
|||Are you using the Database Maintenance Wizard to do your backups by any
change?
Than you should also check the dependencies of SQLMAINT.EXE which gets
called via XPSTAR.DLL xp_sqlmaint
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2mau0plboskh42tcqhfeoovn48rngicnt@.4ax.com...
> Is the full error message:
> Cannot load the DLL xp_star.dll, or one of the DLLs it
> references.
> Reason: 126(The specified module could not be found.).
> If so, you are likely missing one of the files that
> xp_star.dll has a reference to. You can use a dependency
> tool like Dependency Walker (Depends.exe) to list all the
> dependency for xp_star.dll and narrow down which of the
> files is missing.
> -Sue
> On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
> <romyedevelop@.hotmail.com> wrote:
>

cannot load dll xpstar.dll reason 126

Hi
This error message happens when trying to restore/backup a database
(The file exists in the binn directory)
How do I solve it ?
thanks in advance
RomyIs the full error message:
Cannot load the DLL xp_star.dll, or one of the DLLs it
references.
Reason: 126(The specified module could not be found.).
If so, you are likely missing one of the files that
xp_star.dll has a reference to. You can use a dependency
tool like Dependency Walker (Depends.exe) to list all the
dependency for xp_star.dll and narrow down which of the
files is missing.
-Sue
On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
<romyedevelop@.hotmail.com> wrote:

>Hi
>This error message happens when trying to restore/backup a database
>(The file exists in the binn directory)
>How do I solve it ?
>thanks in advance
>Romy
>|||Are you using the Database Maintenance Wizard to do your backups by any
change?
Than you should also check the dependencies of SQLMAINT.EXE which gets
called via XPSTAR.DLL xp_sqlmaint
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2mau0plboskh42tcqhfeoovn48rngicnt@.
4ax.com...
> Is the full error message:
> Cannot load the DLL xp_star.dll, or one of the DLLs it
> references.
> Reason: 126(The specified module could not be found.).
> If so, you are likely missing one of the files that
> xp_star.dll has a reference to. You can use a dependency
> tool like Dependency Walker (Depends.exe) to list all the
> dependency for xp_star.dll and narrow down which of the
> files is missing.
> -Sue
> On Tue, 11 Jan 2005 10:35:23 +0200, "romy"
> <romyedevelop@.hotmail.com> wrote:
>
>

Cannot fine the object “MSmerge_ctsv_... Because it does not exists or you do not have permissio

I keep getting the following error message during the initial merge agent.

· “The merge process was unable to deliver the snapshot to the subscriber.If using Web synchronization, the merge process may have been unable to create or write the message file, when troubleshooting, restart the sychronzation with verbose history loggin and specify an output file to write.

· Cannot fine the object “MSmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4”, Because it does not exists or you do not have permission.(source: MSSQLServer, Error number 15151)

I do see this view in the publication and if I run the following command on the publisher I get…

select * from Msmerge_ctsv_B5ECD41086F24A64B8040A41A75B2DC4

I get

tablenick rowguid generation partchangegen lineage colv1 marker logical_record_parent_rowguid logical_record_lineage

(0 row(s) affected)

I have another publication working on this same server that is working, both are from a copy from a template database.Please advise to what this problem could be and what I can do to resolve this.

Thank you,

Pauly C

The issue was the mobile server name was changed but not dropped and re-added back so the values of@.@.servername and serverproperty(‘servername’) did not match. Once I fixed this everything replicated fine. Not a very intuitive error but if the error returns somethign like "Cannot fine the object “MSmerge_ctsv_..." check the subscriber server name by running

select @.@.servername as oldservername, serverproperty('servername') as newservername, case when @.@.servername <> serverproperty('servername') then '*** Error - Server name changed, replication will not work' else 'Replication friendly' end as cMessage

also this is a script I use to run the procs to drop and add the server...

Use Master

IF (select SERVERPROPERTY('ServerName')) <> (SELECT @.@.Servername )

begin

DECLARE @.SQL VARCHAR(256), @.oldsvrname varchar(128), @.newsvrname varchar(128)

select @.oldsvrname = cast(@.@.servername as varchar(128)), @.newsvrname = cast(SERVERPROPERTY('ServerName') as varchar(128))

set @.SQL = 'Sp_DropServer @.server = ''' + @.oldsvrname + ''', @.droplogins =''droplogins'''

exec( @.SQL)

SET @.SQL = 'Sp_Addserver @.server =''' + @.newsvrname + ''', @.local= ''LOCAL'' , @.duplicate_ok = ''duplicate_OK'' '

exec(@.SQL )

end

** must restart services at this point.

Thank you,

Pauly C

|||Maybe if you would run the agent with a higher OutputVerboseLevel, perhaps it may have given you clues.|||Actually I did that but it gave the same error message.