Groups > comp.databases.ms-sqlserver > #1801

Re: 'Import' scripted DB ?

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> (permalink)
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

Show key headers only | View raw

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!

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-16 07:09 +0200
  Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-16 10:55 +0200
    Re: 'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-16 19:36 +0200
      Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-16 21:42 +0200
        Re: 'Import' scripted DB ? Mads Aggerholm <mads001@xxxxxhotmail.com> - 2014-08-17 20:13 +0200
          Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-17 20:45 +0200
            Re: 'Import' scripted DB ? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:58 -0700
      Re: 'Import' scripted DB ? Lutz <news@invalid.invalid> - 2014-08-18 11:29 +0200
        Re: 'Import' scripted DB ? Erland Sommarskog <esquel@sommarskog.se> - 2014-08-18 10:49 +0000
          Re: 'Import' scripted DB ? Ross Presser <rpresser@gmail.com> - 2014-08-22 08:56 -0700

csiph-web