Connect to master Database using your .NET object. Then run the stored procedure below :
EXEC sp_attach_db @dbname = 'dbname',
@filename1 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname.mdf',
@filename2 = 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname_log.LDF'
Please replace the path to the existing mdf and ldf files. You can also create using
CREATE DATABASE [dbname] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname.mdf' ),
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\dbname_log.LDF' )
FOR ATTACH
GO
command Hope you can do this now.
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.