Encryption ?

Does SQL Server use any type of encryption internally ?
eg. when I take backup of a database is it encrypted if yes then how many bit encryption does it use ?

When a client makes a connection to SQL 2000 server, does it use encryption ? if yes then how many bit encryption is it ?

Any help would be appreciated.

ThanksHi ,

sql server allows for encryption of data for both 16-bit and 32-bit clients with the encryption option of the Multi-Procotol Network Library.

to enable encryption you can select the "Enable multi-protocol encryption" checkbox in the sql server setup program.

hope this clarifies your doubt.

thanks