Re: Change in SQL functionality between 7 and 2k
From: James (James_at_south.africa)
Date: 09/27/03
- Next message: Александр Скляр: "FWD: Prove this correction pack from Microsoft Corporation"
- Previous message: Cathy Ruiz: "Taste these critical patch"
- In reply to: Dan Guzman: "Re: Change in SQL functionality between 7 and 2k"
- Next in thread: Dan Guzman: "Re: Change in SQL functionality between 7 and 2k"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sat, 27 Sep 2003 09:51:24 -0700
Thanks Dan,
At least now I can prove that trying to "fix" the old way
is a dead-end street.
>-----Original Message-----
>The ENCRYPT function is not documented in SQL 7 or 2000,
AFAIK. As
>such, Microsoft can change or remove the function without
notice. If
>you choose to use undocumented functionality, you do so
at your own risk
>because changes may be made between versions or service
packs without
>notification.
>
>> I am in the process of replacing it
>> with more secure methods (if I can get the rest of my
>> company on-board)
>
>This is certainly a good idea.
>
>--
>Hope this helps.
>
>Dan Guzman
>SQL Server MVP
>
>-----------------------
>SQL FAQ links (courtesy Neil Pike):
>
>http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
>http://www.sqlserverfaq.com
>http://www.mssqlserver.com/faq
>-----------------------
>
>"James" <James@south.africa> wrote in message
>news:081601c3845e$b9730120$a301280a@phx.gbl...
>Hi,
>
>Does anyone know why MS changed the way that the ENCRYPT
>('message') function works? I am in the process of
>replacing an old authentication method which uses this
>function because it works differently between SQL 7 and
2K.
>
>Here's an example: on my computer I have SQL 7 running
>alongside a SQL 2K instance. I execute exactly the same
>statement against both instances. SELECT CONVERT(VARCHAR
>(20), encrypt('mysecret'))
>
>In SQL 7 I get what I expect: bЃSLL’v4 пфЏъП
>In SQL 2K I get a unicode translation in clear text:
>mysecret or something similar.
>
>I have found no info about this in technet or in the
>product info for 2000. I am in the process of replacing it
>with more secure methods (if I can get the rest of my
>company on-board) but I still want to know what changed
>and why the chage wasn't documented.
>
>
>.
>
- Next message: Александр Скляр: "FWD: Prove this correction pack from Microsoft Corporation"
- Previous message: Cathy Ruiz: "Taste these critical patch"
- In reply to: Dan Guzman: "Re: Change in SQL functionality between 7 and 2k"
- Next in thread: Dan Guzman: "Re: Change in SQL functionality between 7 and 2k"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
