script for sp_addlogin and sp_addusers

Question

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

check if u can use the script below.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Hadrian Hall of Fame Points: 3742 More actions · Answer 2

I need something like this

check syslogins if they exists

if not create

for each database execute sp_adduser

Johan Bijnens SSC Guru Points: 135548 More actions · Answer 3

DECLARE @command1 nvarchar(2000)

-- Set parameter values

Select @command1 = 'if not exists (select * from master.dbo.syslogins where loginname = N''yourdomain\youruser'')

exec sp_grantlogin N''yourdomain\youruser''

exec sp_defaultdb N''yourdomain\youruser'', N''XLANG''

exec sp_defaultlanguage N''yourdomain\youruser'', N''us_english''

GO

if not exists (select * from dbo.sysusers where name = N''yourdomain\youruser'' and uid < 16382)

EXEC sp_grantdbaccess N''yourdomain\youruser'', N''yourdomain\youruser''

GO '

--print @command1

-- use the undocumented sp_msforeachdb

EXEC @rc = [master].[dbo].[sp_MSforeachdb] @command1

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this