Perfect. Thanks very much for your quick assistance!

Update: After studying SB, implementing it in some test scenarios, and liking it, the decision was made to use the ETL tool Informatica as a queue management tool.

At any...

Thank you for all the comments posted. I'm trying the SB path. I'll report back my experience.

Elliott and Lynn,

Thanks, I will look into that. Are there any concerns about reliability with Service Broker?

I am not really sure what you are asking but, you should have several tables, such as:

Item

ItemInventory

TicketHeader

TicketLine

ItemReceiving

...

...

Also, many store apps use a concept of "closing" or committing certain transactions (sales,...

Yes. I'd create a security group in AD and add users there. In SQL,...

It looks like an install of SQLServer2005_XMO.msi on the developer's pc will allow distribution of the components with the app.

(DMO did require an install of components via registering SQLDMO.dll.)

Kevin Terry (1/15/2008)

---

...I guess my question is does it make sense that a workstation app that uses sql server as a back-end, would need to have sql client tools installed...

Loner,

You should realize that you cannot control all inequities...gotta figure out which battles to fight.  I think you should simply wake up every day with the intention of being the...