Encrypting SPs and maybe triggers, how?

Don't want my sa to be able to tinker with Stored procedures or triggers on
the production machine. I saw some software that had them encrypted. Could
not go in and see their text. How can this be done?
Thanks for any help.
BobUse the WITH ENCRYPTION clause. However, I believe there are tools
available on the Internet to unencrypt the text. Also, note that once
encrypted the object cannot be scripted out for other purposes. Be sure to
save the original DDL in a secure location if needed in the future.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:O9FtvxuuFHA.4040@.TK2MSFTNGP10.phx.gbl...
> Don't want my sa to be able to tinker with Stored procedures or triggers
> on
> the production machine. I saw some software that had them encrypted. Could
> not go in and see their text. How can this be done?
> Thanks for any help.
> Bob
>

Encrypting SPs and maybe triggers, how?

Don't want my sa to be able to tinker with Stored procedures or triggers on
the production machine. I saw some software that had them encrypted. Could
not go in and see their text. How can this be done?
Thanks for any help.
Bob
Use the WITH ENCRYPTION clause. However, I believe there are tools
available on the Internet to unencrypt the text. Also, note that once
encrypted the object cannot be scripted out for other purposes. Be sure to
save the original DDL in a secure location if needed in the future.
HTH
Jerry
"RDufour" <rdufour@.sgiims.com> wrote in message
news:O9FtvxuuFHA.4040@.TK2MSFTNGP10.phx.gbl...
> Don't want my sa to be able to tinker with Stored procedures or triggers
> on
> the production machine. I saw some software that had them encrypted. Could
> not go in and see their text. How can this be done?
> Thanks for any help.
> Bob
>

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangesh
there could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stor...-migration.htm
Regards,

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/sto...e-migration.htm
Regards,sql

encrypting backup in sql2000

Hi
Does anyone know what is the best way to encrypt the backups in sql server
2000.
I know sqllite software but are there any freeware or utilities that
can encrypt the backups.
Tks
Mangeshthere could be others as well but the one I found out randomly is
Mizo - CD Librarian License: Freeware
You can find it:
http://www.dirfile.com/freeware/stored-procedure-migration.htm
Regards,

Enabling MSSQLServerADHelper

I was installing application software that was trying to install SQL Server 2005 and received the following error message.

"Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled."

Simple fix for most but I do not know how to do what it asks.

Thanks, Bruce

Check this out as a good place to start:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939

Buck Woody

http://www.buckwoody.com

Enabling MSSQLServerADHelper

I was installing application software that was trying to install SQL Server 2005 and received the following error message.

"Setup failed because Service MSSQLServerADHelper is disabled for the current hardware profile. Services must be set with the current Hardware Profile logon property profile enabled."

Simple fix for most but I do not know how to do what it asks.

Thanks, Bruce

Check this out as a good place to start:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q313939

Buck Woody

http://www.buckwoody.com