I tried that also it's not working.

i don't have the proper .ldf file. the mdf file is only copied to cd.

The databse is not detached .only copied after stoping the server. now how can i attach the database?

I want to attach the database in a different sever. First i stopped sql server and copied the mdf file into a cd and tried to attach in a different...

The log file is missed. i tried with sp_attach_db it is not attaching

is there any advantage to use

select @SchoolNum = '190'

instead of

set @SchoolNum = '190'

thanx all. it's working perfectly