Updates get queued. Of course, if you delete a column, data is lost or if you should change a column type or size you could lose data.
>I've just realized that I can make changes to a database while users are using the system. What is the impact on the users? Does SQL Server just queue the requests for a split second while the change is made would it cause their database read/writes to fail?
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer