In case it helps:

The server is SQL Server 2000 SP3, running on Windows 2000 Server SP2.

They say youth is wasted on the young, maybe collge is as well.

I can't agree with this statement.  Although when people are younger, they may choose a major that...

Thanks for the ideas, Robert!  I think that might help shed some light on this a bit more for me - gives me some sense of direction.  Thanks again!

Just an additional note:

The tables we'd be interested in combining/replicating are in a third party application. This particular application doesn't use primary keys on their tables.

Although I like the daily email, I wonder if the same could be done for here that you do over on Database Daily, for those who do like the weekly...

Hmm...

Husband's personal, my personal, file server, test box, TV recording PC, handheld, PDA... 7 computers, with plenty of parts for more.

Both my husband and I work in the computing industry...

3 Desktops running Windows XP

1 Desktop running some Windows version I don't remember offhand

1 PDA running Windows PocketPC

1 Handheld running Windows CE

1 server running Debian Linux

I've found that setting the breaks once in the DTS package and then not going back into that screen/wizard part has seemed to work.  My app is much smaller than...

1) SQL Server 2000

2) Follow AJ's suggestion.

3) You may need MDAC (2.8 has been very stable).  Depending on what your application does, you may need other tools.  I'd advise looking...

Is there a reason why you need a function to create the stored procedure rather than have the stored procedure already made?

What are you trying to do?

I prefer to keep Hungarian Notation strictly to the applications and leave them out of the databases.  However, we do end up using some variation of it when naming stored...

I agree with Ken here.  It does seem odd that they'd want a program like this.  If they can justify the need for the SA password and ask nicely for...

To do the copy from A to B, run the Data Transformation Services wizard.  You can open it from the Enterprise Manager.  Go down to the tables level of database...

One thing you might wonder - you can use the EM from SQL 2000 to view SQL 7 servers but you cannot use the SQL 7 EM to view SQL...