Detect User Groups Existence -
05-04-2006
, 11:30 AM
I use the following command when installing a new database to grant access
to MyGroup on SERVER1.
EXEC sp_grantdbaccess 'SERVER1\MyGroup'
What is nice is that if the login for 'SERVER1\MyGroup' is not yet in SQL
Server 2000, it gets added automatically. But I want to do a check to
verify that MyGroup exists on the domain before I run this script? I am
using DTS and can run any stored procedures that I need to.
Thank You,
Derek Hart |