Re: Generate sql script for encrypted stored procedures

From: Mark Broadbent (nospam-mark.broadbent@virgin.net)
Date: 04/17/03 

From: "Mark Broadbent" <nospam-mark.broadbent@virgin.net>
Date: Thu, 17 Apr 2003 14:26:57 +0100

Nhan, you could try
http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14369
http://www.planetsourcecode.com/vb/scripts/ShowCode.asp?lngWId=5&txtCodeId=2
15 

--
BR,
Mark Broadbent mcse+i, mcdba
_________________________
"Andrew J. Kelly" <ajkellynospam@attbi.com> wrote in message
news:OO#BDEOBDHA.1888@TK2MSFTNGP12.phx.gbl...
> I will report the issue of the KB not being able to be accessed.  But as
far
> as the scripts go you need to keep a copy of the script that originally
> generates any encrypted objects somewhere other than the database.
> Preferably SourceSafe.  Once it is encrypted you can script it out.
>
> --
>
> Andrew J. Kelly
> SQL Server MVP
>
>
> "Nhan Duong" <nhanduong@psdus.com> wrote in message
> news:uEmVh3MBDHA.33376@TK2MSFTNGP10.phx.gbl...
> > Hi Everyone,
> >
> > I encrypted my stored procedures in SQL Server 2K to deploy to the
> > customers, but I cannot generate a sql script for those stored
procedures.
> > Could someone tell me a way to do this?
> >
> > I also saw the article #814400 - How to Distribute Encrypted Stored
> > Procedures Between Instances of SQL Server 2000  in the Microsoft site,
> but
> > I cannot access to this, any help?
> >
> > Thanks in advance!
> >
> > Nhan Duong
> > nhanduong@psdus.com
> >
> >
>
>

Relevant Pages

  • Re: Scripting T-SQL CREATE Statements
    ... a backup of user-defined SQL Server objects. ... I am having a hard time finding the T-SQL functions and system stored procedures used to return the scripted ... like when you right-click an object and select Script Object to New Window as>> Create. ... I am trying to get it much like the instnwnd.sql file that comes with the .NET Framework SDK v1.1. ...
    (microsoft.public.sqlserver.programming)
  • Re: Strongly Type Datasets
    ... Schema for that login. ... It won't create the stored procedures. ... The SQL script it generates is based on a SQL login so the script looks ... some way or my permissions are wrong in SQL Server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Can I search for a string in a set of stored procedures?
    ... want to go through a database full of many stored procedures to find ... my version of Sql Server Management Studio? ... Alternatively stored procedures of the database can be scripted by ... Microsoft) to script each stored procedure to individual files. ...
    (comp.databases.ms-sqlserver)
  • Re: Convert Express To Server
    ... transfer all of my tables,views, stored procedures and data from one to ... your Express database was used in a User Instance but the database files ... Use of included script samples are subject to the terms specified at ... Sql Server 2005 db? ...
    (microsoft.public.sqlserver.setup)
  • Re: Generate sql script for encrypted stored procedures
    ... Thanks Andrew and Mark, ... I want to distribute a sql script encrypted the stored procedures ... > Nhan, you could try ...
    (microsoft.public.sqlserver.security)