What's the response that you get from a select @@version

What I've done in the past is to make the destination server also the monitor server and use the same domain service accounts on both boxes so that I eliminate...

This works fine, well you have to make it a varchar not a vaschar, but that's just semantics.

You have the log and data files on the same RAID5 array? I would recommend getting the logs off to another array (RAID1) first and foremost, that's a huge performance...

Thanks, just the kind of thing that I was looking for.

Have you tried using perfmon?

Other than that, in the short term Quest has a tool called Spotlight. It's pretty much a real time monitoring tool. It works okay, however is...

I believe the tool that you are looking for is SQLPing, you can download it from http://www.sqlsecurity.com/

Works great, unless of course you have the server behind a properly configured...

How is your memory usage on the server? If sql is not taking it all and you have plenty of free memory within the chunk that SQL does have I...

You are going to be emailling the user their new password, or just a single user?

Is the batch a SQL sp or something external?

I would use an sp to change...

Is your web application killing the connection once the page is done, or are you using connection pooling?

Connection pooling will leave the conneciton open so that another page can use...

I would also only kill those processes for certain logins as well. It would not be good to kill a login that is sleeping but is ultimately responsible for your replication.

Are you actually replicating data changes, or are you actually making data/schema changes, confirming those changes and then manually pushing those changes out?

When you say that you have about 6GB of data to transfer is that the initial load of the database or is that the size of your transaction log dumps...

I would check and confirm that the sql server agent account on each of your servers has sufficient permissions on the others. It could be that it cannot retrieve or post...

If you really want to get rid of SQL Server and start again you could follow the steps in http://support.microsoft.com/default.aspx?scid=kb;EN-US;290991 

I have been forced to use this in the past...