限制SQL Server只让指定的机器连接
怎样才能限制我的SQL Server只能让指定的机器连接http://www.mypcera.com/softxue/7/sql/0034.htm
3. Write a constantly running/scheduled stored-procedure that checks the relevant column in sysprocesses (net_address), and then issues a KILL command for any processes that should not be running. Note that this only works for MAC addresses. This way allows people to connect and possibly make changes before they are spotted and killed.
写一个存储过程检查sysprocesses中的相应列(net_address)
请问这个存储过程怎样写?