Thanks. That would solve the problem.

I also found through another sites discussion thread that by checking the SQL Server 7.0 format check box under command line in DTSRUNUI, it...

I have never worked with replicating views. If I use a view, will the data end up in the underlying tables on the subscriber? Or just a materialized view there?

I kept experimenting with the Width parameter to the stored procedure and found that providing it a value of 320 allows me to get the eMails without the extra lines....

In a previous reply I did indicate that there was a BEGIN TRAN on the first connection before the first Insert. And I believe you are right that just closing...

I would love the developers to change the code so they use the @@Identity. This is a much better solution than using NOLOCK. Unforetunatly, for this move to SQL 2K,...

This is all happening inside one explicit transaction: Begin Tran, Insert into Table1 (on connection1), Select max() from table1 (on connection2) then insert into table2 (on connection1). And yes, there...

The SQL Plus session was being run from the Server console, not a client. I have resolved this problem. It turns out that the SQL server was not stoppped and...

I used my own account which was a sysadmin account using SQL Server authentication.

I have a tip that problem might be resolved by stopping and restarting SQL Server. SQL Agent...

Yes. I can access the oracle database from SQL Plus (the Oracle version of Query Analyzer) and I have no problem connecting. We are using Oracle Client version 8.0.5

Mark Hottinger

I ran the package at the server console, not from a client.

Mark

Mark Hottinger