Check to be sure that he hasn't changed the permissions on the tables or columns. All should list ARSystem as dbo. Also, if he set up any additional indexes, be sure that those aren't the problem.
Rick On Thu, Oct 16, 2008 at 10:11 AM, Brandi Barbour < [EMAIL PROTECTED]> wrote: > ** > All, > We have windows 2003 with sql 2005, ARS 7.1.0, ITSM 7.0.3. Our database > engineer set up SQL replication for our production sql server to our backup > sql server. The problem is that when he does the SQL replication set up the > remedy system does not agree with it. We get errors when someone modifies a > request and it pushes a value to a char field with an attached menu with the > pattern = $MENU$. It says that the value we are sending does not meet > $MENU$. We also get errors if we go to the admin tool and try to move a > field.. Errors concerning the sql view does not exist. It seems that > somehow the views are being changed. I know someone on the list had said > that the replication adds columns to the views so the system is not > recognizing the views correctly. I have seen some questions on arslist but > did not know if anyone had a solution as of yet. > Has anyone successfully set up SQL replication successfully? > Thanks, > Brandi > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
