SQL 2000 equivalent script for this SQL 2005 script

• John Eisbrener

  Mr or Mrs. 500

  Points: 509

  More actions

  December 17, 2008 at 7:19 am

  #216602

  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

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  December 17, 2008 at 8:16 am

  #913868

  try sp_revokelogin or sp_denylogin to prevent members of a group or account from logging in.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• John Eisbrener

  Mr or Mrs. 500

  Points: 509

  More actions

  December 17, 2008 at 8:59 am

  #913923

  sp_denylogin did the trick. I've been trying revoke, but that just removes the account entirely from the server. Thanks!