- Login and application role passwords stored in SQL Server
- Any data sent between the client and the server as network packets
- Stored procedure definitions
- User-defined function definitions
- View definitions
- Trigger definitions
- Default definitions
- Rule definitions
If you're willing to get into the world of undocumented functions and such, then you might want to consider pwd_encrypt( ) and pwd_compare( ). You can use pwd_encrypt to store an encrypted value into a column. You will never know what the value is, nor can you view it. But you can compare values to it, such as in a WHERE clause, using the pwd_compare function. I do NOT recommend this approach!
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on SQL Server Database Modeling and Design
Related Q&A from Kevin Kline
Monitoring and Administration expert Kevin Kline discusses the obstacles of database administration when a publisher resides on a different domain. Continue Reading
A common SQL Mail error is addressed by monitoring and administration expert Kevin Kline. Continue Reading
Monitoring and Administration expert Kevin Kline discusses the installation of SQL Server client tools on Windows XP Pro. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.