Reelix's place to mess around, and really do as he pleases.... Really :p
Monday, May 6, 2013
Create a SQL Database using an existing MDF File
If you have an MDF file, and you need to create a SQL Database from it using code, do the following:
USE [master]
GOCREATEDATABASE [insert_database_name_here] ON
( FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\Data\fileNameHere.mdf' ),
FOR ATTACH ;
GO
No comments :
Post a Comment