Tuesday, March 2, 2010

Create Data Base Files on Remote Machine

DBCC TRACEON ( 1807 )DBCC TRACEstatus ( 1807 )
USE [master]GO/****** Object: Database [Test4] Script Date: 10/07/2009 18:22:48 ******/CREATE DATABASE [Test4] ON PRIMARY ( NAME = N'Test4', FILENAME = N'\\dnet01\share\Test4.mdf' , SIZE = 2048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'Test4_log', FILENAME = N'\\dnet01\share\Test4_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) COLLATE SQL_Latin1_General_CP1_CI_ASGODBCC TRACEOFF (1807)

No comments:

Post a Comment