Re: Printing my Stored Procedures

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 05/12/04


Date: Wed, 12 May 2004 14:44:16 +0100

Try scripting them in Enterprise Manager. It is pretty straight forward.

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"Simon Harvey" <simon.harvey@the-web-works.co.uk> wrote in message
news:ecZSVaCOEHA.1276@TK2MSFTNGP11.phx.gbl...
Does anyone know if its possible to get hold of all my stored procedures and
somehow output them all to a text file for printing.
I have quite a lot now and I need to be able to set them all up as a batch
on other servers. Unfortunately I don't have them in one file
Any help would be greatfully received
Kindest Regards
Simon


Relevant Pages

  • Re: so slow DDQ update statement...
    ... Vyas, MVP (SQL Server) ... SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/ ... > Vyas, MVP ...
    (microsoft.public.sqlserver.dts)
  • Re: Stored procedure question
    ... Vyas, MVP (SQL Server) ... > where UserID = @UserID ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: delete a system sp
    ... Vyas, MVP (SQL Server) ... >> how to rename or delete a stored procedure .. ...
    (microsoft.public.sqlserver.security)
  • Re: Question about check contraints
    ... that CHECK constraint is looking for. ... Vyas, MVP (SQL Server) ... > Vyas, MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Lost Permissions after Detach/Attach
    ... Vyas, MVP ... > Did you move those databases to a different machine/different domain? ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)