After creating subscription and while running it comes out with an error

"could not able to find stored procedure SP_MSupd_EscalationJobControl".

venkatesh

Hi Andy,

Transactional type is working fine for me, where ever i update source , snapshot agent is updating subscriber, But if i create any tables/objects how this will reflect in...

Adding to previous , what is the best replication type can be configured for transfering data from source database to reporting database in some time intervals

venkatesh

Thanks for your quick help, it did worked successfully, there was dll missing in the default directory. I recollected that I had removed this part of security to disable xp_cmdshell....

what is the best process of unregistering, without restarting sql server as this is production database.

venkatesh

what is the default location of xplog70.dll .

venkatesh

I have executed that , the result is below

name ...

The login has sysadmin rights .

venkatesh

The only doubt is if i detach DB files and Attach datafiles , is there will be any issues with logins connecting to that databases.

venkatesh

Thanks Andy, I was doing same thing but is there are any specifiec counters where group to get the apporiate results.

Let me know if you any samples.

venkatesh

Configuration of ours,

We have two nodes, SQL1 and SQL2 with Active / Passsive. We need to create the second instance which will use for different client, Still it will...

Thanks for all your help guys, It worked by restarting the SQL Agent, By the way we are running on SQL2K SP3.

venkatesh

Let me know one thing every time when we change the job schedule or any job details we need to restart the sqlagent service.

MSSQLAGNET has been started and job has...

I have checked the log file but I didn't find any thing related to jobs

venkatesh

I am not getting any errors, that's where the problem is.

venkatesh