We have a client with 2 connected SQL servers, development & production. I
am having a problem using DTS to move objects between the 2. If I use the
option to DTS tables and data, it all works fine - so connection is not the
issue. However if I try to use the option to DTS objects, such as stored
procedures, I get the message 'An error occurred' (real helpful) and the
I dont know where to start on this. I guess I could recommend they
reinstall SQL on both servers but there is perhaps a less dramatic ...