Thanks and duh on my part.

Thanks. Do you happen to have the webmaster’s email address handy. I’m in the doctors office and the WIFI is terrible, so it’s hard to search.

Thanks

That’s an interesting thought. I think it might make sense for my particular situation.

Thanks. I’ll keep that in mind. In my application the widgets table is rarely modified and it’s the only table that’s affected.

Given that I suspect it’s not a problem.

Thanks again to both of you. I hadn’t considered the issue of re seeding. I’m familiar with SQL Server, but not experienced enough to have seen all the gotcha’s.

Am I...

Thanks to both of you. I can add anything to the table as I am in the process of creating it. I had thought about using date time as my...

You’ve brought up some interesting points. That I will surely look into. One reason I posted my question was that I’ve always used and never had a problem with these...

Thanks. I agree with you and plan to use check constraints as a compromise as I seem to be losing this battle. My way of thinking is to do things...

Thanks. You obviously know SQL Sever better than I do. I will look this over as soon as I can.

Thanks. The a bit of good information (sorry for the pun about using bits).

Thanks for getting back to me. I tend to agree with you. I thought it best to have the support table for referential integrity despite the performance hit for the...

Lynn, all good points. My brother in-law has an app that is actually going through this same process. He wants the customers to own the data, but some want him...

Jamie you raise some interesting questions. At this time I don't have the answers because I was pulled onto another project for the next few months. I will...

SebastianT (12/18/2014)

---

In cases like this, I am always strongly in favor for having a separate database for each customer, for the following reasons:

1. Easy to backup and restore the data...

GilaMonster (12/18/2014)

---

The other thing to think about is that the database is the unit of restores. Will you ever be required to revert customer 42's data back to how it...