Aha! I think this is the crux of the matter...right now it's the third option for my login, but I think I need to make it the fourth option and...

Should I delete the existing linked server before running the system sp's?

Thank you for your reply -

Donna

Hi, Steve - This post was tremendously helpful to me, so I wanted to share my thanks for the great script. I poked around, looking for the subscription emails enough...

It's not easy data to replicate on some fake way, and I thought of this as some technique-driven thing where someone could just recognize the situation amd say, "oh, I...

Some people are entertained by fast cars...others by fast code...GO GEEKS, I say. 🙂

I really liked this article - very thorough. EXCEPT seems to be an analog to the Oracle MINUS, so sometimes I like it because I feel like I really...

Is it a linked server? If so, then why not a simple "select * into table b from table a" where table b is the four-part name? Alternatively, you could...

Is it a linked server? If so, then why not a simple "select * into table b from table a" where table b is the four-part name? Alternatively, you could...

Hi, Pablo - You're right - my eye passed over that part of your answer. Sorry about that! One of those things that I know of, but have...

Thank you, I appreciate the input - it confirms what I've heard (in a scattered sort of way). I'm in the process of coding my UPDATE version to test...

Thanks, Luke - that's what I was thinking of doing, and what I meant when I said that I was going to write the code both ways and then "race"...

This is not a question asking "how to" do either one of these things - I know how to do them. I'm just curious with regard to preference/performance -...

Given the complexities of date data, I always do an explicit convert to a specific type, then do my compare - so with your example, I would say:

select ENTRY_DATEfrom...

Thank you for your reply, I appreciate it.

I right clicked on the shared datasource pointing to the the dev datasource, after I had added the prod datasource, and selected "disassociated...

Hey, some nice variations on a theme! 🙂 One of the many things I love about programming. Thanks, guys!