Merging problem... "The process could not drop one or more tables..." 
Author Message
 Merging problem... "The process could not drop one or more tables..."

Hi,

We are building a merge system. The system has one main server as a
subscriber and several measurement pc's as publishers.

The merge between one measurement pc and the main server works fine. When we
try to connect a second pc SQLServer gives the following error:

"The process could not drop one or more tables because the tables are being
used by other publications."

This bug is reported (BUG # 55330 SQLBUG_70), and should be fixed after
installing Service Pack 2. But after installing SP2, the error message still
appears.

Could it be that something went wrong during the installation of SP2, or am
I doing something wrong?

Regards,

Wiebe.

Btw. we use a push subscribtion, the error appears during the snapshot.



Fri, 04 Apr 2003 03:00:00 GMT
 Merging problem... "The process could not drop one or more tables..."

Hi,

I got an answer in "microsoft.public.sqlserver.replication", I haven't tried
it jet, but it looks promissing.

--
AIR technical Automation
www.air.nl

Quote:
> Hi,

> We are building a merge system. The system has one main server as a
> subscriber and several measurement pc's as publishers.

> The merge between one measurement pc and the main server works fine. When
we
> try to connect a second pc SQLServer gives the following error:

> "The process could not drop one or more tables because the tables are
being
> used by other publications."

> This bug is reported (BUG # 55330 SQLBUG_70), and should be fixed after
> installing Service Pack 2. But after installing SP2, the error message
still
> appears.

> Could it be that something went wrong during the installation of SP2, or
am
> I doing something wrong?

> Regards,

> Wiebe.

> Btw. we use a push subscribtion, the error appears during the snapshot.



Sun, 06 Apr 2003 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Merging problem... "The process could not drop one or more tables ..."

2. "Process Cube" not working in Tutorial

3. Dropping a table with "sp_executesql"

4. Cannot drop table "CURRENT"

5. Fastes way to "merge" tables

6. snapshot distribution returns "cannot drop table"

7. SQL "DROP TABLE" on Jet 4.0

8. dts cubes processing "Invalid processing option"

9. max of ("...","...","..")

10. "deadlocked with another process" problem

11. The process could not bulk copy into table '"dbo"."MSmerge_contents"'.

12. The process could not bulk copy into table '"dbo"."MSmerge_genhistory"'.


 
Powered by phpBB® Forum Software