Re: [RadiusNT] concurrency checking problem with roaming

David Routh ( drouth@davlin.net )
Wed, 11 Oct 2000 13:25:15 -0500

>Thats a lot of overhead. All new installs of Emerald use this script:
>
>CREATE PROCEDURE RadCheckOnline @Username varchar(64) AS
>SELECT COUNT(*) FROM ServerPorts (NOLOCK)
>WHERE Username=@Username AND AcctStatusType in (1,3)
>GO
>
>Which is much faster and does what you want.
>

Would it be OK to replace the old sp for RadCheckOnline with the new one
above? Are there any gotcha's to be aware of...

Thanks, David

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart