If you have three systems, for example, a devel server, test server and Production server, then make the ids start at 1 and increment by 3 on the devel server...

I will have to make a few assumptions here and one of those is that you have correctly set up the connection and that you are getting access to the...

You only have to replace a single quote with two single quotes when you are inserting a record. When you are comparing the records you only need to compare...

Suser_Sname() will get your network name, however, if people are logging on from outside your network this will not work. What is your front-end application?

Edward M. Sokolove

Yes, it can be done. I would send a parameter to the stored procedure and iterate through the stored procedure with a loop and continually pass the new value...

Yes. I have physical access to the server... and I have the perl script being executed via a batch command. The DTS package executes the batch script fine....

Try creating a batch file that executes the perl script and run the batch file from your DTS package. This works for me. Here's the batch file I...