I have not set this up to run yet, but I have looked at the code. The following code toward the end stands out:

SET @sql =

'INSERT ' + @tblname

EXEC...

what error(s) do you get when executing this SP?

Robert W. Marda

SQL Programmer

bigdough.com

I don't use this product.

I prefer to have SQL Server do everything it can and for that reason would reject any product that would control backup and restores. To...

You can explore using the table variable if you have SQL Server 2000. This would move the load from the tempdb to memory. I don't know if this...

I don't know if this will help or not, but we got a similar error because of SQL Server version incompatibilities with using client tools from version SQL Server 7.0...

Can you post the errors and/or the stored procedures being called? Do you know if the problem is with the first stored procedure or the second? If you...

The bulk logged recovery mode does not allow point in time recovery. It allows you to recover to the end of a transaction log backup. Also bulk copy...

I won't claim to be an expert, but I don't think upgrading to NT SP 3 would slow down your DTS packages.

Did anything else change on your network? Were...

The only issue we ran into when upgrading from SQL Server 7.0 to SQL Server 2000 was that we were using the word Function (and we still are) as a...

And if you are using SQL Server 2000, you can experiment with table variables to see if that performs better for you. Then it stores the data in memory...

I prefer reading the newsletter from SQL Server Central. It is the most organized of all the online newsletters for SQL Server that I have seen and almost every...

try this:

INSERT INTO TABLE (FIELD) VALUES('''')

Robert Marda

SQL Server will deliver its data any way you want it

when you give your SQL Programmer enough developing time.

go to the table sysobjects and search for the table in question. make sure you allow modifications to sys tables and then change the column xtype from 'S' to...

If both SQL Servers are on the same network you should be able to open the DTS package and then save as and change the server name to the server...

Well, what Antares describes sounds like you can call it an internal trigger (as mentioned by jeffwe). I am going to see if I can capture anything with profiler...