You want to replicate from ServerA to ServerB, and from PROD_DB to TEST_DB ... (databases with different names)  ??   Sure. I don't have any databases with the same name.

I found the problem. The user's Windows account needed to be in the Distributed COM Users group on the server. 

Thanks ... I probably should have given some more information to narrow it down. Another developer has "sysadmin" rights, and he doesn't have any problem.  Neither do I, also sysadmin....

I tried a few with the wizard and they succeeded. But I can't figure out how to edit them. How do you open the damn things ?  I connect to...

I use different maint plans for backups & trans logs without a problem. If the log backup tries to run while the full backup is running, it will fail, but...

If all else fails, perhaps you could install it as a different instance.

FYI   IE 6.0

Here's my version:

CREATE TABLE [dbo].TableSchema(

[table_name] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[column_order] [smallint] NULL,

[column_name] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[column_datatype] [sysname] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

Our Financial package, Lawson, required that collation for their database. All our other databases use the "normal" collation. We have a few situations where we join tables between Lawson and...

Without knowing the details, it sounds like DTS should do the job.

In either 2000 or 2005, you can have SQL generate the change script for you, then cut & paste it to run against your other tables. That's what we do....

There are also different collations within English. For example, most of our databases use a collation that is case INSENSITIVE, but one of our databases requires a collation that is...

I don't then you should even ask them about what to wear on the interview. Then it sounds as if you're trying to get out of dressing up - cutting...

What are you backing up ?   Is this SQL related ?

I'm using the SQL2005 Management Studio for my 2000 databases, but Scriptio is only for 2005 databases. Any other ideas for scripting out individual files ?  Currently, I go back...