Below are books (that I have contributed to in some way or form) that include information about SQL Server security.
SQL Server Security - Osborne Press.
Special Ops: Host and Network Security - Syngress.
Hacking Exposed: Windows 2003 - Osborne Press.
Web Hacking : Attack and Defense - Addison-Wesley.
SQL Server Security Distilled (reviewer)