5 Replies Latest reply on Nov 15, 2006 12:11 PM by lusciousmango

    Moving tables between dbs as a scheduled event

    lusciousmango Level 1
      Basically, I need a current user table in two databases, without having to add new users to two separate dbs.

      I'm trying to set up a scheduled event that will delete the User table from database A, and copy a table of the same name from database B into database A. I'm assuming that since I'm using two separate databases that I can't use a stored procedure.

      Anyone have any suggestions? I tried to use a DTS wizard to copy the contents of dbA.table into dbB.table, but it vomited on a primary key error.