The query you've mentioned should work, except it won't stop new SPIDs from connecting after you have run it. You may also have to wait a long time for any...

I'd actually recommend that you use windows authentication wherever possible for the following reasons:

1. You will immediately know who is accessing your data - with SQL Authentication, it's not always...