Transferring databases between SQL Server instances

Question

I have mdf & ldf files from another machine and want to add these databases to my machine, how can I do that?......Thanks

When I try to attach the database I get the following error:

Error 602: could not find row in sysindexes for database id 7 object id 1. Run DBCC CHECKTABLE

Answer 1

Second question - use sp_attach_db.

Answer 2

If you're trying to attach files created by a newer version of SQL Server, that may be your problem