Re: decrypt function in SQL Server 2000

From: Dan Guzman (guzmanda_at_nospam-online.sbcglobal.net)
Date: 11/16/04


Date: Tue, 16 Nov 2004 08:32:28 -0600

To add to Hari's response, undocumented functionality can change between
versions or even service packs and thus break your code. Avoid using
undocumented stuff in production.

-- 
Hope this helps.
Dan Guzman
SQL Server MVP
"jzhou" <jzhou@discussions.microsoft.com> wrote in message 
news:0DC77411-9710-4A06-A502-EE1DC61DAE54@microsoft.com...
>I know that there are undocumented encryption function, such as:
>
> pwdencrypt
> pwdcompare
>
> anyone know what is the decrypt function in SQL Server 7.0/2000. If you 
> know
> any, please provide syntax and some simple examples.
>
> Thanks a lot 


Relevant Pages

  • Re: SQL DBA per Server
    ... Data Warehouse Architect ... Production DB hat. ... Microsoft SQL Server MVP ... automation. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL DBA per Server
    ... Production DB hat. ... "Geoff N. Hiten" wrote: ... Microsoft SQL Server MVP ... automation. ...
    (microsoft.public.sqlserver.server)
  • Re: SQL DBA per Server
    ... Production DB hat. ... "Geoff N. Hiten" wrote: ... Microsoft SQL Server MVP ... automation. ...
    (microsoft.public.sqlserver.server)
  • Re: Production statistics data storage
    ... If you're concerned with performance, LINQ should not be considered--not until they figure out how to get it working. ... SQL Server is fully capable of good performance--even when polled frequently. ... Production statistics with quality indications is a major part of the ... statistics over number of produced units and percent produced in each grade. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Is the msdn sql enterprise 2005 version downloadable production?
    ... Jasper Smith (SQL Server MVP) ... >> keys so I don't see why it matters what media you install it from). ... >> Edition on MSDN subscriber downloads cannot be installed in a production ...
    (microsoft.public.sqlserver.setup)