That's really interesting, but I do not seem to have scptxfr.exe or the path 'C:\program files\Microsoft SQL Server\mssql\upgrade\'?

My pleasure. I should get some sleep though, I've got a root canal tomorrow (seriously!).

Good points all. I think that on a shoestring youo can use manual procedures to fix up the holes, but I agree, there is a real lack of a...

Interestingly, "Loose Coupling" is how Microsoft describes Service Broker's use in applications development.

Jeff Moden (10/20/2008)

---

rbarryyoung (10/20/2008)

---

Jeff Moden (10/20/2008)

---

Heh... which definition of "diatribe" do you mean here? 😛

1 archaic : a prolonged discourse

2: a bitter and abusive speech or writing

3: ironic or satirical...

Glad it worked out.

In my experience, heterogeneous replication is best implemented in SQL Server with Service Broker.

Heh,...

I am a little curious, why can't you just script the database that you have modeled or reverse engineered and then propagate that script?

This essentially is what you can do with Service Broker, only without having to use xp_CmdShell.

You should be aware of course that if the strings are being provided by other users, that this would be an injection target.

Sounds like a foreign Key reference.

Great story, Ron. Thanks for digging that up.

Your ProductAttribute is really a ProductAttributeValue table and it should not have the ProductAttributeID in it as it can be completely determined by the AttributeValueID.

Unless, the AttributeValueID is not really...

Fair warning: Installing Outlook on a Server is no small feat. It takes some work.