I have the linked server name correct and it is also qualified with the other server's domain name as well. It used to work before so I'm not sure...

Lowell,

Sorry I forgot to post the error (below). Trying to run this statement logged in as a user with 'sysadmin' permissions.

Msg 7202, Level 11, State 2, Line 1

Could not...

Lutz,

I didn't think of that, but it worked!!! YOU ROCK!!!

Thanks much!!!

-David

That's what I thought, but I needed confirmation.

Thanks! 🙂

Phil,

I ran the SELECT only and there are no NULLS in the result set.

Please advise.

Thanks,

David 😀

All,

After I changed the query to the one below and received the following error:

Msg 515, Level 16, State 2, Line 1

Cannot insert the value NULL into column 'subisonum', table 'Vimas.dbo.VimasProFast1';...

-- insert statement

INSERT INTO VimasProFast1

SELECT MONTH(dbo.MerInfo.addtosys) AS month,

...

All,

I must doing something wrong as all the examples that were posted are still giving me a duplicate error.

Any ideas?

Thanks!

Yikes! Sorry, I forgot to attached the doc. Thanks for the heads up!!!

Will do. Thanks for your input and many thanks!!!

We haven't eliminated the option of deleting the dup values, but the idea of using a trigger seems probable.

Thanks

Hi Pam,

Yes, I understand the purpose for creating the UNIQUE INDEX or UNIQUE CONSTRAINT is for uniqueness. We're trying to prevent dup values in the table moving forward that's...

Craig,

No problem I understand your position and thanks for letting me know. I actually have a collegue that is going to assist me so I think I should be...

Craig or Phil,

Your suggestions are great. I wanted to know if either one had some time today or this morning and would be willing to connect to shared...

My bad on the Chris, I meant Craig.