You have to be careful with this as the database could have been opened exclusive. In this case, if I remember correctly, the table is opened EXCLUSIVE also.
>USE .. SHARED opens a table in non-exclusive mode, even if SET EXCLUSIVE is ON.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
