how to decrypt the contents of ctext column in syscomments table

From: ganesh wayachal via SQLMonster.com (forum_at_SQLMonster.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 12:09:38 GMT

hi
i want to know how to decrypt the contents of ctext column in syscomments table through that can i get information about the parameters passed to stored procedure are mandatory or optional. 

-- 
Message posted via http://www.sqlmonster.com

Relevant Pages

  • RE: Programmatically decrypt stored procedure?
    ... know how to decrypt stored procedure, to keep the integrity of newsgroup, ... Secondly, from your descriptions, I understood that you may want to decrypt ... script(Use the Generate SQL Scripts dialog box) into the Execute SQL task. ... Create a database with encrypted objects and use this database for the ...
    (microsoft.public.sqlserver.dts)
  • Re: sp_prepexec and sys_comments
    ... Syscomments is for code that is persisted in a SQL Server database, ... a stored procedure, function, view, etc. Prepared statements are not to be ...
    (microsoft.public.sqlserver.odbc)
  • Re: Output stored procedures as text problem
    ... "Renaming a stored procedure, view or trigger will not change the name of ... the corresponding object name in the syscomments table. ... except that the output file does not reflect the ... > Dim objSQLServer As New SQLDMO.SQLServer ...
    (comp.databases.ms-sqlserver)
  • sp_rename _BUG_
    ... Renaming a stored procedure, view or trigger will not change the name ... will be inserted from the syscomments table into the CREATE statement. ...
    (microsoft.public.dotnet.languages.vb)
  • sp_rename _BUG_
    ... Renaming a stored procedure, view or trigger will not change the name ... will be inserted from the syscomments table into the CREATE statement. ...
    (microsoft.public.sqlserver)
Loading