We load up our data warehouse every day with the sales info for the pervious day. I have them set as scheduled jobs with mulktiple steps. I would like to keep the users out while this is happening. What would be the best way to do this. Should I change have the first step as change db to dbo only/singe user. And then add another step after its all done to change it back so users can get in.
Stacy
Stacy
