I have a SQL Server 7.0. I wish to move the secondary data files associated with a huge database to another drive with more space. This is pretty straightfoward in SQL Server 2000 by doing detach/attach DB.
How do I accomplish this in SQL Server 7.0?