Re: Utility

From: David Portas (dportas_at_acm.org)
Date: 12/06/04


Date: 6 Dec 2004 04:44:55 -0800

I think you are referring to the ability to encrypt source code. SQL
Server supports a WITH ENCRYPTION option on CREATE PROC, VIEW and
FUNCTION statements. Unfortunately, the encryption method isn't very
secure. It is easily broken with freely downloadable tools.

There are third party tools that claim to help secure your SQL Server
code. You can Google for those.

-- 
David Portas
SQL Server MVP
--


Relevant Pages

  • Re: SSIS as part of scheduled job fails
    ... might not have Encryption support, but it shouldn't be trying to use SQL ... Microsoft SQL Server Management Studio ...
    (microsoft.public.sqlserver.dts)
  • Re: SSL Sicherheitsfehler
    ... SQL Server 2005 german evaluation enterprise installiert ... Die Encryption war die ganze Zeit aus.Dann kam der SSL Fehler. ... SQL Server herstellen. ... TURN ON SSL encryption on the SQL ...
    (microsoft.public.de.sqlserver)
  • Re: Data encryption for results of query using ADO
    ... i read somewhere that there is a way to encrypt and xml output from sql ... > I'm using ADO to connect to a SQL Server. ... > Can I enable encryption for a specific connection to the SQL Server without ...
    (microsoft.public.sqlserver.programming)
  • Force Protocol Encryption - Please help!
    ... I just recently set up a SQL 2000 server and have a question about ... so I enabled the Force Protocol Encryption ... After installing the cert, I was once again able to start my SQL ...
    (microsoft.public.sqlserver.security)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)