Replication and linked server securityI haven't had a lot of good luck using "be made using the login's current security context" in the past. Sadly we're not using service accounts properly at the moment so the set spn's that would work to allow Kerberos authentication that would allow the security context to be forwarded isn't in place. I can see if it works though.

Setting up simple question & answer databaseI don't see the need for AnswerGroupQuestions when you could just put a non-nullable FK to AnswerGroups in the Questions table since one question can only have one Answer Group.