the accounts on both servers that are used for the copy.

Check that the alias does not point to a different server.

Des the account that you are using have access to see all the procs? And have you confirmed that there are no alias entries in the client network utility that...

I would set up regular trans log backups on the publishing server. It will help retain the db recoverability, without the log getting uncontrollable in size.

Are the ones that are not copied user or system procs?

What does the postsnapshot do?

I have a postsnap that creates some indexes on a large table and takes some time to complete. After 20 minutes I get the no response...

Personally I pull the filename into a global variable and assign the variable as a part of the data pump using activex

Function Main()

 DTSDestination("FileName") = DTSGlobalVariables("gv_TableName").Value

 Main = DTSTransformStat_OK

End Function

Subban, you are running a select * from the table with no where clause. As such the index does not even come into play. Were you using a where, or...

I would

1. I would create a new domain account.
2. Change the service to that account (through EM).
3. Restart.
4. Change the service back to the old account (through EM).
5. Restart the service....

"This problem occurs if you are running SQL Server 2000 with an affinity mask that is set to use a multiple of seven processors. "

from MS http://support.microsoft.com/?kbid=890755

By the looks of things you have 3 indexes on the A & B columns (a primary key, clustered unique key and non-clustered), plus an index on B.

I would drop...

Have you tried rebooting all the servers involved (if you are able) ?

But is it actually listening on 1433? Check the server configuration utlity.

How about checking the port that SQL is listening on?

I would check that there is no issue with you DNS servers. If you are able to connect with the IP and not the server name it would indicate that...