Re: newable copy question

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 01/18/05 

Date: Tue, 18 Jan 2005 08:24:30 -0500

The easiest way is to right click on the database in Enterprise Manager and
choose "All Tasks" - "Generate SQL Script". Make sure you select all the
items you want and it will generate you the script to recreate the db and
what ever objects you selected. 

-- 
Andrew J. Kelly  SQL MVP
"RioDD" <RioDD@discussions.microsoft.com> wrote in message 
news:9EF2C331-DC6F-4D58-90B7-AB08E4D661AA@microsoft.com...
> Hello
> I'm application developer, and I have to copy the test database from the
> development server to another server, with the stored procedures, but 
> without
> the data in the tables. Any sugestions how can I do this or where can I 
> read
> how can I do that?
> Thanks

Relevant Pages

  • Re: How to extract texts of all stored procedure
    ... Right click on the database in Enterprise Manager and select "All Tasks" and ... then "Generate SQL Script". ... > I need to extract the texts of all procedures of a database. ... Regards. ...
    (microsoft.public.sqlserver.server)
  • How can I check..
    ... The easiest way is to do into Enterprise Manager, ... by selecting the database, all tasks, generate sql script, ... >I have one database file in separate filegroup. ...
    (microsoft.public.sqlserver.server)
  • Re: .sql File
    ... > In Enterprise Manager, right click on the database, select ... > All Tasks and then select Generate SQL Script. ... In the options tab, you ...
    (microsoft.public.sqlserver.clients)
  • Export more than one table at the same time
    ... when using Enterprise manager, I would like to export the data from my ... generate sql script: ... This creates the database for me, but the data is not restored. ... Thx, ...
    (microsoft.public.sqlserver.tools)
  • Re: Missing file from MS.NET Compact Framework Kick Start
    ... let apologize for the missing files in our samples. ... The readme.txt file from Chp 9 in describes how to set up the test database ... is a sql script file that will set up the Quotes database on the server. ...
    (microsoft.public.dotnet.framework.compactframework)