How to check a security account already exists in the database?

• Unnikrishnan.C

  Old Hand

  Points: 320

  More actions

  August 19, 2005 at 3:21 am

  #165721

  Hi,

  I am using sp_grantdbaccess to add a security account in a database. But if the account already exists, it will give an error: 'User or role 'VOIP' already exists in the current database'.

  >EXEC sp_grantdbaccess 'George', 'Georgie'

  Before calling 'sp_grantdbaccess' I want to check whether the account 'Georgie' already exists in the database.

  How can I do it?

  Thanks

  Unnic

• sushila

  SSC-Dedicated

  Points: 35293

  More actions

  August 19, 2005 at 6:20 am

  #583481

  you could run a query like this in the master db....

  select name, dbname, hasaccess from syslogins

  
  
  
  
  
  
  **ASCII stupid question, get a stupid ANSI !!!**