[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 343
  • Last Modified:

add into 'BUILTIN\Administrators' through TSQL

is it possible to add users into the above group using tSQL, instead of windows?

Thanks
0
anushahanna
Asked:
anushahanna
1 Solution
 
Karim-SaidCommented:
you can use the foolowing SP to enumerate user groups
xp_logininfo 'domain\groupname' , 'members'

but you can't use TSQL to add groups

you can use a script like in this URL if you are looking for a programmatical way
http://msdn.microsoft.com/en-us/library/ms676310(VS.85).aspx

Best Regards,
migo
0
 
anushahannaAuthor Commented:
Thanks.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now