Scripting Users and Logins - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Scripting Users and Logins

Author

Topic

X002548
Not Just a Number

15586 Posts

Posted - 2009-01-08 : 13:25:06

I thought someone use to have a script to do this, but I can't find it.

Also, 2k5 Security is painful

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-08 : 14:50:32

If you are referring to transferring logins between instances, then check out my blog for code that I wrote to do this:
http://weblogs.sqlteam.com/tarad/archive/2008/06/24/How-to-transfer-SQL-logins-between-SQL-Server-2005-instances.aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2009-01-09 : 09:29:15

thanks...what about users?

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-09 : 09:36:01

Brett,

I use this one:(This is best one)
http://support.microsoft.com/kb/246133

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-01-09 : 11:27:29

I don't transfer users ever. We either get them with a restore or via our build scripts.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources