Monday, 2 April 2012

To create the Database using quries in SQL Server

USE [master]
GO
-- Method 1: I use this method
EXEC sp_attach_single_file_db @dbname='Test_WCF_3',
@physname=N'F:\LAWRENCE\Personal\WCF\WCF.mdf'
GO
-- Method 2:
CREATE DATABASE Test_WCF_2 ON
(FILENAME = N'F:\LAWRENCE\Personal\WCF\WCF.mdf')
FOR ATTACH_REBUILD_LOG

No comments:

Post a Comment