Anyone have a trick up their sleeve that simulates this SQL 2005 only script on SQL 2000?
USE [master]
GO
CREATE LOGIN [DOMAIN\Account] FROM WINDOWS WITH DEFAULT_DATABASE=[master]
GO
DENY CONNECT SQL TO [DOMAIN\Account]
GO
This specific account is part of an AD group that has permissions to the database, but I want to specifically deny access to this one account and this is the easiest (and most straightforward, imho) way to take care of this special case.
Any and all suggestions are welcome.
Thanks,
John