New Install Help

An error occurred while executing query:

Line 2: Incorrect syntax near 'copy'.

"Kaib> execute following command in Administrator program:

execute following command in Administrator program: exec sp_detach_db 'RMSSample', 'true' copy rmssample.mdf and rmssample.ldf to drive D exec sp_attach_db @dbname = N'RMSSample', @filename1 = N'D:\rmssample.mdf', @filename2 = N'D:\rmssample.ldf'

I am sorry for the confusing.

1. Run exec sp_detach_db 'RMSSample', 'true' in Admin program.
2. Move your database files(RMSSample_Data.mdf and RMSSample_Log.ldf) to Drive D:, database files should be in 'C:\Program Files\Microsoft SQL Server\MSSQL\Data'
3. Run exec sp_attach_db @dbname = N'RMSSample', @filename1 N'D:\rmssample_data.mdf', @filename2 = N'D:\rmssample_log.ldf'

Thanks for the help, after the execution I got the msg below

Query executed successfully

-1 records (s) affected

do I need to do anything else or this should do it.

SA Baker

"Kaib> I am sorry for the confusing.