I don't know how you'd get this stat, but you are missing a large percentage of people who don't work and don't need/want to... (and I mean paycheck type work, so don't yell at me for the next sentence, I know they work a lot more than I do), stay at home parents, independently wealthy, day traders, drug dealers, etc.

This is more for a restore after they do something dumb ... like "I just deleted all the invoices for customer A when I meant B; can you get them back?" My answer would be I can put your data back to 3am last night, you'll loose everything you did today but your invoices will be back.

I guess I could if I turned identity insert on and then just delete all for a company and then import ... I'll think on that one ...

We have a web application using SQL Server 2008 R2 that contains data for tracking time that another company has expressed interest in using, we initially set up the database such that all end-user tables have a foreign key to what company that row belongs to. Is there a good way to backup/restore the data for a specific company across the tables, such that if the new company says tomorrow that they want their data restored to yesterday; it can be restored without impacting all the other companies data as well? I'm trying to avoid writing some form of stored procedure that selects and then have to do an insert/update/delete to put the data back. Thanks for any insight.

Dennis Daugherty

classy_dog, double click on the dbml file and on the view menu choose server explorer add a link to the server your database is modeled from (you may already have one), you can click in any white space in the dbml diagram and look at the properties->connection->connection string to get the connection string. Once you have the server connection you can just drag the table(s) into the diagram.

I think the word you were look for was Deprecated :-D

The same. I just missed the s ... and I love the parking lot scene, and I keep calling things "wirery"

Mine are My Cousin Vinny and the Replacement ... it seems I just can click past them.

I like Drupal. He just said .NET preferred.

You can get a skeleton website up in 30 minutes, then spend 3 months looking for skins, there are that many to choose from. If you want to skin it yourself then, less than a week.

Our company has DotNetNuke for dozens of sites now. http://www.dotnetnuke.com. Community version is free.