In the enterprise manager for sqlServer when you create an index,
you're locked out of the whole application. You can't use the EM to
examine or modify anything else - you have to wait for it to finish (thank
goodness you can schedule most of these for late at night).
>>
I agree in general that checklist can be misleading, but I'm wondering why
all the negative comments about SEM. I'll be the first to admit that it is
not as elegant a design from a GUI/interactive design as som other Windows
products but it is head and tails above most of the tools you have to BUY
from other DB vendors.
BTW, you could always simply open up a second SEM when you're building
you're index. Or you could have simply run the command from an isql/w
window...
--
Brian Moran
Senior Architectural Engineer
DataFocus Inc
MCSE, MCSD, MCT
President, Washington D.C. SQL Server Users Group
Received on Thu Aug 08 1996 - 00:00:00 CEST