home *** CD-ROM | disk | FTP | other *** search
/ Computer Shopper 132 / dpcs0299.iso / Business / Superoff / super / Sql / SOINIT.MQL < prev    next >
Encoding:
Text File  |  1996-11-08  |  197 b   |  9 lines
  1. PARAMETERS password, database
  2.  
  3. exec sp_addgroup SOUSER
  4. exec sp_addgroup SOADMIN
  5.  
  6. exec sp_addlogin SO, {password}, {database}
  7. exec sp_adduser SO, SO, dbo
  8. exec sp_role "grant", "sa_role", SO
  9.