Duplicate Table Names in 2 databases problem

[ttektek]

Hi Guys,

I have problem with asp and SQL Server 2000. I have two databases with identical table names, but separate databases. In my asp if I update 1 database with values, it also updates the table with the same name in the other database.

I have checked the asp and it is pointing to the correct database.

Is the duplicate table names causing the problems?

Thanks

Sami

 

[ArtieChoke]

Is replication set up between the databases? That could be a cause of the duplication. Just because the names are the same shouldn't cause this is your connection is to only one of the databases.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[LazyMe]

Or maybe there's a trigger defined on the table you're updating?

Greetings,
Rick