I also had same issues where patch update for SQL Server 2008 R2 BIDS (Shared features) got failed due to devenv.exe.config.tmp file.

I looked for this devenv.exe.config file on...

There is a great feature from SQL Server 2012 on wards which allowed us to upgrade Evaluation edition to any paid version of SQL Server 2012.

https://technet.microsoft.com/en-us/library/ms143393(v=sql.110).aspx

hi it's good and working fine.

we have no sync transaction replication so, there is no error and it's workig fine after sp_replrestart .

Thanks Very much

Rajni kant ranjan

I think answer should be

xp_ServiceControl 'QueryState', 'SQLServerAgent'

this because if no job will run then sysprocesses will not have any process related to that service. So, i think answer as...

Hi

Can you tell us that Publisher having which version of SQL Server?

Thanks & Regards

Rajni Kant Ranjan

Senior SQL DBA

Hi!

as per your error you have to check the service login id of both servers and connection userid and password of both servers. Becuase problem is only with these things.

Thanks...

Thanks Travis to provide interesting topics like that before that i was very confuse about NULL.

Thanks ................................

Excellent jobs