It is in the system views for each DB. look for sys.sysaltfiles
>>Thank you all for your efforts. I did try this also, and while the IF condition is important, it is not critical. The bigger trouble is that it does not find the correct sysaltfiles and I get several errors:
>>
>>Invalid object name 'dbo.sysaltfiles'.
>>
>Yes, I got the same errors too. BTW, where is sysAltFiles? I was trying to see it, but I can not.
Thank You
Rollin Burr
Politicians and diapers have one thing in common. They should both be changed regularly, and for the same reason.