View Single Post
  #5 (permalink)  
Old October 29th, 2008, 03:14 PM
navyjax2 navyjax2 is offline
Registered User
Points: 12, Level: 1
Points: 12, Level: 1 Points: 12, Level: 1 Points: 12, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Oct 2007
Location: , VA, USA.
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

See http://www.experts-exchange.com/Prog..._22856885.html

Code:
CREATE LOGIN [DOMAIN\username] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]
GO
EXEC sys.sp_addsrvrolemember @loginame = N' DOMAIN\username, @rolename = N'sysadmin'
EXEC sp_addrolemember 'db_owner', [DOMAIN\username]

Reply With Quote