"Noor" <noor@ngsol.com> wrote in message
news:uc9EkWaXEHA.3512@TK2MSFTNGP12.phx.gbl...
> I have created the Following view but gave me an error while decrypting
> the View..
>
> CREATE VIEW MyTopCities
> WITH ENCRYPTION
> AS
> SELECT DISTINCT TOP 10 PERCENT ShipCity, ShipRegion
> FROM Orders
> ORDER BY ShipCity
>
> EXEC dbo.DECRYPT2K MyTopCities,'V'
>
> Server: Msg 2812, Level 16, State 62, Line 1
> Could not find stored procedure 'dbo.DECRYPT2K'.
>
>
> Thanks
>
> Noor
>
>
>
>
>
>

"Hari" <hari_prasad_k@hotmail.com> wrote in message
news:%23RDAm6bXEHA.4000@TK2MSFTNGP09.phx.gbl...
> Hi,
>
> Microsoft is not providing any procedure the decrypt the views ,
procedures
> , triggers ....It just provides
> a mechanism to encrypt.
>
> I feel that "DECRYPT2K " is a third part procedure. So you need to create
> this procedure first before executing.
>
> Download the code from below link:
>
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=505&lngW
> Id=5
>
> I have never tested this before, try it out.
>
> --
> Thanks
> Hari
> MCDBA
> "Noor" <noor@ngsol.com> wrote in message
> news:uc9EkWaXEHA.3512@TK2MSFTNGP12.phx.gbl...
> > I have created the Following view but gave me an error while
decrypting
> > the View..
> >
> > CREATE VIEW MyTopCities
> > WITH ENCRYPTION
> > AS
> > SELECT DISTINCT TOP 10 PERCENT ShipCity, ShipRegion
> > FROM Orders
> > ORDER BY ShipCity
> >
> > EXEC dbo.DECRYPT2K MyTopCities,'V'
> >
> > Server: Msg 2812, Level 16, State 62, Line 1
> > Could not find stored procedure 'dbo.DECRYPT2K'.
> >
> >
> > Thanks
> >
> > Noor
> >
> >
> >
> >
> >
> >
>
>