RE: Extract source of all stored procedure

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: David Portas (REMOVE_BEFORE_REPLYING_dportas_at_acm.org)
Date: 02/21/05


Date: Mon, 21 Feb 2005 08:35:09 -0800

In Enterprise Manager. Right-click the DB. All Tasks > Generate SQL Script.

-- 
David Portas 
SQL Server MVP 
--


Relevant Pages

  • Re: image field
    ... Query Analyzer will show a hex representation of IMAGE data but I don't ... think it's possible in Enterprise Manager. ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver)
  • Re: order of columns
    ... > i know full well that enterprise manager can insert another column ... But EM recreates the table, populates it and then drops the ... David Portas ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Alter Database Move column
    ... Tibor Karaszi, SQL Server MVP ... > Is it possible to move a column using an SQL script? ... > alter table MasterStationTest ...
    (microsoft.public.sqlserver.server)
  • Re: Input File Variables
    ... And I suppose if I had multiple variables I wanted to pull in, ... could parse it ) once I have it inside the sql script? ... David Gugick - SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Is there any tool (freeware) to generate SQL Script for the data present in the database
    ... SQL Server MVP ... "Peri" wrote in message ... > Is there any tool (freeware) to generate SQL script for the data present ...
    (microsoft.public.sqlserver.programming)