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

Re: 'Import' scripted DB ?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!us.feeder.erje.net!feeder.erje.net!eu.feeder.erje.net!eternal-september.org!feeder.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: 'Import' scripted DB ?
Date	Sun, 17 Aug 2014 20:45:46 +0200
Organization	Erland Sommarskog
Lines	16
Message-ID	<XnsA38CD335E7B33Yazorman@127.0.0.1> (permalink)
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>
Mime-Version	1.0
Content-Type	text/plain; charset=windows-1252
Content-Transfer-Encoding	8bit
Injection-Info	mx05.eternal-september.org; posting-host="944e8a95b2bfa5abbf0e792f87734688"; logging-data="12320"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19VuF3O/umaB556F9u5txlt"
User-Agent	Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32)
Cancel-Lock	sha1:2m3I+E1P2AMxGR4w/q63mC74NbQ=
Xref	csiph.com comp.databases.ms-sqlserver:1792

Show key headers only | View raw

Mads Aggerholm (mads001@xxxxxhotmail.com) writes:
> Thanks a lot, I forgot the login and password. Damn!
> Now I've come to the next step, facing other difficulties, but at least 
> I'm in.
> I think I can take it from here.
> Thanks again.
> 

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.

-- 
Erland Sommarskog, Stockholm, esquel@sommarskog.se

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