SQL Database comparison

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dougancil
    Contributor
    • Apr 2010
    • 347

    #16
    CK,

    here's the error when I run my proc:

    Server: Msg 208, Level 16, State 1, Procedure newcustomers, Line 4
    Invalid object name 'msbtotal.dbo.m embers'.

    Comment

    • ck9663
      Recognized Expert Specialist
      • Jun 2007
      • 2878

      #17
      Did you run it this way:

      Code:
      EXEC YourProcedure

      Comment

      • dougancil
        Contributor
        • Apr 2010
        • 347

        #18
        I did. Just like that.

        Comment

        • ck9663
          Recognized Expert Specialist
          • Jun 2007
          • 2878

          #19
          And you run it in a new query window, not being called inside another proc? Are you in the same DB? Are you calling any other proc? What version of ms sql server are you using?

          ~~ CK

          Comment

          • dougancil
            Contributor
            • Apr 2010
            • 347

            #20
            Nope, the query is ran in a new query window. I am in the same db. I am not calling any other proc and this is running on a SQL 2000 server.

            Comment

            • ck9663
              Recognized Expert Specialist
              • Jun 2007
              • 2878

              #21
              The only remaining thing that I can think of is to list the column names that you are populating on the INSERT clause and the corresponding column name you are trying to insert to the table on the SELECT clause.

              You might also want to create a copy of newclients table with a different name and insert it to that table instead.

              Are you using any CALCULATED columns? Functions? Triggers? Constraint? etc?

              ~~ CK

              Comment

              • dougancil
                Contributor
                • Apr 2010
                • 347

                #22
                I can try to create a new table and insert it into that but in answer to your other question, I'm not using any other triggers, or constraints or any calculations.

                Doug

                Comment

                • dougancil
                  Contributor
                  • Apr 2010
                  • 347

                  #23
                  CK,

                  I created a new table (newclients2) and inserted the data. For whatever reason that worked. It seems that the table "newclients " had something wrong with it, but I've fixed that and it seems to work correctly.

                  Thanks for your help.

                  Doug

                  Comment

                  Working...