SQL Database comparison

[dougancil]

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

[ck9663]

Did you run it this way:

EXEC YourProcedure

[dougancil]

I did. Just like that.

[ck9663]

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

[dougancil]

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.

[ck9663]

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

[dougancil]

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

[dougancil]

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