My mgmt. would like some Reporting Services reports out of CMS.  While I kno
w
the DB is proprietary, I ran a trace during key CMS events (ie update a page
,
etc).  I see the flow and in the process of breaking down the process I
noticed the CMS stored procedures are encrypted.

Is there a script or something that I can run to unencrypt my MCMS stored
procedures in my SQLServer 2005 database?

Thanks

Tom

[ Post a follow-up to this message ]

Hi Tom,

direct access to the database is not supported.
Afaik it is not possible unencrypt encrypted stored procedures. This is
prohibited by SQL Server.

Cheers,
Stefan

"Tom" <Tom@discussions.microsoft.com> wrote in message
news:5D3BAED8-24E4-4C41-9FD8-756D1D06406D@microsoft.com...
> My mgmt. would like some Reporting Services reports out of CMS.  While I
> know
> the DB is proprietary, I ran a trace during key CMS events (ie update a
> page,
> etc).  I see the flow and in the process of breaking down the process I
> noticed the CMS stored procedures are encrypted.
>
> Is there a script or something that I can run to unencrypt my MCMS stored
> procedures in my SQLServer 2005 database?
>
> Thanks
>
> Tom
>
>
>

[ Post a follow-up to this message ]

Hallo Tom,
Cms schema is not supported by MS to change/view it. If you will change
anything, you can experience difficulties when migrating.
For decrypt Sql server procedures, try search for How to descrypt Sql
server procedure.
But, it is not easy to find something from them 

Martin

Stefan Go=DFner [MSFT] napsal:[vbcol=seagreen]
> Hi Tom,
>
> direct access to the database is not supported.
> Afaik it is not possible unencrypt encrypted stored procedures. This is
> prohibited by SQL Server.
>
> Cheers,
> Stefan
>
> "Tom" <Tom@discussions.microsoft.com> wrote in message
> news:5D3BAED8-24E4-4C41-9FD8-756D1D06406D@microsoft.com... 
ed[vbcol=seagreen] 

[ Post a follow-up to this message ]