Glad you got it working!
>Thanks Tracy, worked like a charm! In the attach dialog it assumed the old names and I had to correct those manually. I then renamed the database using the SQL manager interface, then corrected one instance of the logical name in the database properties.
>
>>You should be able to just detach the database, rename the files, and then attach them again.
>>
>>
>>>I would like to rename my MDF and LDF files. Example ECPVGH.MDF and ECPVGH.LDF to ECPVCH.MDF and ECPVCH.LDR. In enterprise manage, if I rename the database, this only renames the logical name, but the MDF and LDF files remain with the old name. Same goes for using sp_renamedb.
>>>
>>>Any ideas?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"