cI am just trying to restore PrismDataSave from a PrismData backup

Thank you for your kind words,

I have done this before.

What is the syntax?

I added the repl_distribution as a user on the subscriber.

No Luck.

The log reader is working. Changed from a Domain Account to SA.

Agent 'ASSET2629\PUBLISHER-AdventureWorks2014Pub-MyFirstPublication-ASSET2629\SUBSCRIBER-3' is retrying after an error. 67 retries attempted. See agent job history in the Jobs folder for...

BrainDonor (12/18/2015)

---

For your original problem, a Google search provided a large number of results. https://www.google.co.uk/?gws_rd=ssl#safe=active&q=%22Cannot+execute+as+the+database+principal+because+the+principal+%22+replication

Check the owner of the Publisher DB - make sure it is a valid account.

For the...

Welsh Corgi (12/18/2015)

---

When I try and start the Log Reader Agent for Transaction Push REplication I get the following error:

The process could not execute 'sp_replcmds' on 'ASSET2629\PUBLISHER'. (Source: MSSQL_REPL, Error...

Adventureworks2014

Transactional Pull

I also had to execute:

EXEC sp_dropdistributor @no_checks = 1, @ignore_distributor = 1

GO

Distribution was not installed correctly.

I executed the following command and it removed the publication:

sp_removedbreplication @dbname = N'AdventureWorks2014Publisher'

The command executed successfully but it does not delete the publication.

Error: Could not find stored procedure. :ermm:

Thanks for the script.

Does it only script out the transaction Logs since the last Diff?

I went threw the wizard but I believe that I did something wrong.

I can't delete the Publication. Could not find Stored Procedure.

Is there...

Jennifer Noelle Dunklin (9/22/2007)

---

I figured it out. The column was too narrow to capture the complete script that was generated by the store procedure sp_scriptpublicationcustomprocs. I went into Tools, Options,...

Lynn Pettis (12/14/2015)

---

Welsh Corgi (12/14/2015)

---

Lynn Pettis (12/14/2015)

---

Here is how I look at it. If the people who build, create, and maintain the servers (physical or virtual) have decided to...

Welsh Corgi (12/9/2015)

---

Jeff Moden (6/12/2015)

---

I can't speak for anyone else and I'm sure that it will rub some folks' sensibilities the wrong way but I do install the full monty...