I didn't find a way to attach sql 2000 database to my new sql 2005 expression because I don't have all the client tool. but by using the "EXEC sp_attach_db" command you can easily attach a database.
example:
----------------------------------------------------------------
EXEC sp_attach_db @dbname = N'NewSpringboard_v2',
@filename1 = N'D:\Program Files\Microsoft SQL Server\MSSQL.2 \MSSQL\Data\NewSpringboard_v2_Data.mdf',
@filename2 = N'D:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\Data\NewSpringboard_v2_Log.ldf'
----------------------------------------------------------------
Wednesday, March 29, 2006
Subscribe to:
Posts (Atom)