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 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: References: <53eee78b$0$23648$edfadb0f@dtext02.news.tele.dk> <53ef9675$0$23649$edfadb0f@dtext02.news.tele.dk> <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 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