X-Received: by 10.236.124.161 with SMTP id x21mr9178205yhh.48.1408723081408; Fri, 22 Aug 2014 08:58:01 -0700 (PDT)
X-Received: by 10.182.236.106 with SMTP id ut10mr48528obc.19.1408723081206; Fri, 22 Aug 2014 08:58:01 -0700 (PDT)
Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!usenet.blueworldhosting.com!feeder01.blueworldhosting.com!peer03.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!m5no1943266qaj.0!news-out.google.com!ef6ni6161igb.0!nntp.google.com!uq10no3415997igb.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: comp.databases.ms-sqlserver
Date: Fri, 22 Aug 2014 08:58:00 -0700 (PDT)
In-Reply-To: <XnsA38CD335E7B33Yazorman@127.0.0.1>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=71.168.140.56; posting-account=SOVadwoAAAB3h7W1MLW9kMYtEc2JW2L8
NNTP-Posting-Host: 71.168.140.56
References: <53eee78b$0$23648$edfadb0f@dtext02.news.tele.dk> <XnsA38B6F1513E6AYazorman@127.0.0.1> <53ef9675$0$23649$edfadb0f@dtext02.news.tele.dk> <XnsA38BDCDB39B2BYazorman@127.0.0.1> <53f0f0d8$0$23639$edfadb0f@dtext02.news.tele.dk> <XnsA38CD335E7B33Yazorman@127.0.0.1>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <553ac560-edff-41ea-98e5-698a54d131f8@googlegroups.com>
Subject: Re: 'Import' scripted DB ?
From: Ross Presser <rpresser@gmail.com>
Injection-Date: Fri, 22 Aug 2014 15:58:01 +0000
Content-Type: text/plain; charset=ISO-8859-1
X-Received-Bytes: 1716
X-Received-Body-CRC: 4200518909
Xref: csiph.com comp.databases.ms-sqlserver:1801

On Sunday, August 17, 2014 2:45:46 PM UTC-4, Erland Sommarskog
wrote:

> One thing I forgot to say: add the option -d tempdb, so that the
> script starts running in tempdb. Else if the initial CREATE
> DATABASE statement and/or the USE statement fails, you will litter
> the master database with tons of objects.

What a good idea! I've stomped on my master db several times in the
past. Thanks!