GilaMonster (12/29/2015)

---

BrainDonor (12/29/2015)

---

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical...

Eirikur Eiriksson (12/29/2015)

---

I really appreciate the effort of those who write the articles posted on this site but sometimes the quality seriously suffers from the absence of technical review and...

Readability.

Sometimes a query may perform better if it uses sub-queries instead of CTEs, but if it isn't a major issue I'll use a CTE because the code is easier...

Typo, or something more interesting we might all want to learn from?

Talib123 (12/21/2015)

---

This query has issues due to the \.

If I use a Where = it works fine. How do I get around this small annoying issue.

SELECT name FROM sys.syslogins

WHERE name...

What is the issue? Using '=' or 'in' both work in my tests.

Please show the code and the error that you're seeing.

https://msdn.microsoft.com/en-us/library/ms186858.aspx Example E is a good starting point.

I don't have access to a PC over this weekend, but that name looks like a server name - not a database name.

Are you sure you aren't getting the names...

Does the log-reader agent's account have the correct permissions against the publisher, and is the default schema correct when you check it via the Security settings for that database?

To actually see what...

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 new...

I'd forgotten that nonsense from years ago - good riddance to it.

I'll ask the question that we all want to know the answer to...

How recent are your backups?

Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/

Hopefully that's a better venue than the previous Liverpool SQLBits.

Registered for...