Re: encrypted proceduers

Hi Josppy,
I think that Erland already pointed out the table (syscomments) to which
you can query. To make it more clear to you, I write the following T-SQL
statement for your reference:
Use database_name
Go
select objs.name,objs.id,cmets.encrypted,cmets.text from sys.sysobjects
objs join sys.syscomments cmets on objs.id = cmets.id
where objs.type='P' and cmets.encrypted=1
Go

Please do not hesitate to let us know if there is anything unclear.

Best regards,
Charles Wang
Microsoft Online Community Support
=========================================================
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg@xxxxxxxxxxxxxx
=========================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================



.

Relevant Pages

  • RE: EF: selecting all the relations of a relation
    ... The entity framework ... query like this, ... Microsoft Online Community Support ... You can send feedback directly to my manager at: ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Query xml data in the table of sql server 2005
    ... and then I run the same query as yours to update the test column ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.programming)
  • Re: How make subform independent of main form?
    ... operator with a subquery in the SELECT list? ... The following query should work: ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.access.formscoding)
  • Re: encrypted proceduers
    ... you can query. ... To make it more clear to you, I write the following T-SQL ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.security)
  • Re: Unable to edit data in table in Management Studio 2005
    ... the issue might be related to the SSMS. ... please use T-SQL to insert/update the date. ... Microsoft Online Community Support ... Please feel free to let my manager ...
    (microsoft.public.sqlserver.clients)