How Do I: Block Connections to SQL Server by IP Address Using Logon Triggers?

This podcast, the speaker tells about how to restrict access to SQL Server 2005 SP 2 (Or Above) based on IP Address. This demo shows how to:- Retrieve the IP Address of the client using the EVENTDATA() function-Use a Logon Trigger to restrict access to a SQL Server instance