attaching database

HI all,
I 'm trying to attach a database to my local SQL server. Right mouse click
on Database -> all tasks -> Attach Database. I then select the appropriate
mdf file but two red crosses appear over the files I want to import. I can't
even click ok OK.
Someone knows whats going wrong? I 'm using SQL Server 8.0
regardS
StijnProbably due to the files being relocated to a different path. I find it
easier to use the sp_attach_db stored procedure for this. You can just list
all the file names at their new locations. See Books Online for the full
syntax.
--
David Portas
SQL Server MVP
--|||Stijn Goris wrote:
> HI all,
> I 'm trying to attach a database to my local SQL server. Right mouse click
> on Database -> all tasks -> Attach Database. I then select the appropriate
> mdf file but two red crosses appear over the files I want to import. I can't
> even click ok OK.
> Someone knows whats going wrong? I 'm using SQL Server 8.0
> regardS
> Stijn
>
or maybe mdf-file is read-only?