We have recently upgraded from SQL 7 to 2000 and noticed that all the DTS packages that use local as the server name within a connection will no longer work. Using Makepipe and Readpipe I get a status = 2 error. I was able to find an article describing the error code from Readpipe but unfortuantly, it started with 3. Now, in order to get local to work without having to modify all the DTS packages, I created an alias for local in client utilities to use TCP\IP. I also tried to connect via Query Analyzer using local and without the alias, I get a connection error. I would appreciate any input. Thanks
Kelly Ennis