DECLARE @Role varchar(20) = 'UserRole'
IF NOT EXISTS (SELECT name FROM sysusers
WHERE issqlrole=1 AND name = @Role)
EXEC sp_addrole @Role; --EXEC sp_addrole @Role, 'dbo'
Showing posts with label sp_addrole. Show all posts
Showing posts with label sp_addrole. Show all posts
Add DB Role IF NOT EXISTS
Check if the Database Role exists before creating it:
Subscribe to:
Posts (Atom)
Posts
