index > SQL Server Security > Maximum length for passphrase?

Maximum length for passphrase?

Learning 101: I was unable to determine a maximum length for the "passphrase" used in ENCRYPTBYPASSPHRASE.

1. Is there a maximum (such as 255 characters?)

2. I assume the longer the passphrase the more difficult the encrypted result will be to crack. Is that true?

TIA,

barkingdog

barkingdog Thursday, March 19, 2009 10:31 PM

The limitation for the passphrase length should be given by the allowed data types, and it should 8000 bytes, which means 4000 Unicode characters.

I hope this information helps.

-Raul Garcia
SDE/T
SQL Server Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

Proposed As Answer byRaul Garcia - MSModeratorFriday, March 20, 2009 2:15 AM
Marked As Answer bybarkingdog Friday, March 20, 2009 2:22 AM

Raul Garcia - MS Friday, March 20, 2009 2:15 AM

The limitation for the passphrase length should be given by the allowed data types, and it should 8000 bytes, which means 4000 Unicode characters.

I hope this information helps.

-Raul Garcia
SDE/T
SQL Server Engine

This posting is provided "AS IS" with no warranties, and confers no rights.

Proposed As Answer byRaul Garcia - MSModeratorFriday, March 20, 2009 2:15 AM
Marked As Answer bybarkingdog Friday, March 20, 2009 2:22 AM

Raul Garcia - MS Friday, March 20, 2009 2:15 AM

You can use google to search for other answers

Custom Search

More Threads

• Find LoginName for user

• Is there an accesible record or repository of information concerning security patches and updates which concern SQL Server (any version)?

• A rewrite of the sp_help_revlogin procedure (use at own risk)

• What Permissions are Needed to Drop All Connections on a Database?

• Disabling Windows Authentication Mode in SQL SERVER 2005

• sp_setapprole question....

• Sql Express groups on a Domain Controller

• encryption passphrase hard coded into tableadaper selectcommand , is it safe ?

• Change database master key - 3.6.4 PERIODIC CRYPTOGRAPHIC KEY CHANGES

• Permission on View not on Table