1

I'm using SSMS 2014 for SQL Server 2008 R2.

Why don't I see 'configure distribution' when I right-click on Replication?

enter image description here

Improve this question
0

1 Answer 1

Reset to default
0

I found that the distribution and publication wasn't correctly disabled. When I tried to run the disable the publishing and Distribution (as seen in my image above) I was getting an error that the process couldn't complete because the distribution database was still in use. so I used

SELECT spid FROM sys.sysprocesses WHERE dbid = db_id('distribution')

to find the spid that was using it and then used 

KILL <the spid>

I was then able to fully disable the publishing and Distribution and now I do see the configure distribution option. enter image description here

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.