Is it possible to assign a DB role to a DB user in Sql Server 2008 using t-sql? If so, how?
+3
A:
From BOL: exec sp_addrolemember @rolename = 'db role', @membername = 'db user'
Strommy
2010-06-30 17:17:25
Thanks! Btw, what's BOL?
Asaf R
2010-06-30 17:42:12
BOL = Books Online. It's the SQL Server help document. It's the best place to look this kind of thing up (it's actually the best help documentation I've seen on a piece of SW to date).
Strommy
2010-06-30 17:59:50