I don't quite follow whats going on. You can't do what you are
descibing above. You can expand a log device, but you can't just
change a data device to a log device. If you have expanded the
log segment of your tempdb on error (rather than the data segment),
then you could shrink the tempdb log segment and expand the
data segment.
-- Dale E. Reed Jr. (daler@iea.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com