Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.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: I have a database mdf made in Sql Server 2008 on a Vista machine. Date: Fri, 07 Mar 2014 21:33:54 +0100 Organization: Erland Sommarskog Lines: 17 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 8bit Injection-Info: mx05.eternal-september.org; posting-host="fd3d6d0229f14a752f017d8f9903addd"; logging-data="11182"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19bbZS87zrrwS3SyDhS5std" User-Agent: Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) Cancel-Lock: sha1:AB2pLWcWFvPmc9O4YlPUmEx61/M= Xref: csiph.com comp.databases.ms-sqlserver:1705 Tony Johansson (johansson.andersson@telia.com) writes: > If I just go to Sql Server Management Studio and choose task on the > database and then Generate script I will not get the data from this > database. If you ask for it you will. If you don't ask for it, you will not. In SSMS 2008 the scripting wizard brings you to the page with scripting options. One of them is Script Data. In SSMS 2012 this page is not displayed automatically. You need to press the the Advanced button in the third screen. -- Erland Sommarskog, Stockholm, esquel@sommarskog.se