|
Home > Archive > Microsoft Content Management Server > November 2006 > Unencrypt CMS '05 Stored Procs
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Unencrypt CMS '05 Stored Procs
|
|
|
| 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
| |
| Stefan Goßner [MSFT] 2006-11-22, 1:15 pm |
| 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
>
>
>
| |
| markcz 2006-11-23, 7:28 am |
| 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]
|
|
|
|
|