If you want to do it via a script.....in Sql Server 7 you can save the package as a file.  Then you need to open up this .DTS file and replace the server name...

Hi, Here is the code. I am stumped as to why it doesn't work.  Thanks for your help.

Function Add ()

Dim objConn

Dim objSPCmd

Dim paramUserName

Dim paramFirstName

Dim paramLastName

..more here

Dim lngRecs

On...

We tried using the hint WITH (NOLOCK) on a table that was getting a lot of acess and was causing blocks and it has seemed to resolve our blocking.