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.
| Author |
Topic |
|
ttheobald
Starting Member
2 Posts |
 Posted - 2006-06-06 : 17:17:00
|
| Hmm. Under SQL 2k, we had sp_SidMap. 2k5, in its infinite wisdom, seems to have broken that with their read-only system views.Soooo....what's the new equivalent of sp_SidMap? Is there a solution? There has to be, since the only alternative is to manually regenerate logins/users, and that would be stupid.Not that MS hasn't been known for stupid moves, but since 2/3rds of them are ex-Borlanders, I have come to expect a little more out of Redmond. T |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-06 : 17:20:26
|
| I've never heard of sp_SidMap and I can't find it on my servers. Could you provide more information wherer I can find it?Are you sure that you aren't looking for sp_change_users_login? Or another DBA wrote this sproc or downloaded it off the Internet?Tara Kizeraka tduggan |
 |
|
|
ttheobald
Starting Member
2 Posts |
Posted - 2006-06-06 : 17:27:25
|
| sp_SidMap harnesses sp_change_users_login to do a mass-update of all users/logins for a particular database. You can actually get it here searching this forum:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37335&SearchTerms=sp_sidmap...but it chokes when attempting to update the SID value in the sysusers view (formerly table, now a RO view). My frustration level is running pretty high with this, so please forgive the brevity of my reply here. T |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-06-06 : 17:33:19
|
| Here is an alternative that I use now instead of sp_change_users_login. I do not know if it will work on SQL Server 2005 or if it can be easily reworked to work on 2005.http://www.sqlmag.com/articles/index.cfm?articleid=16090&The best part about it is that it copies the sid over, so you don't need sp_change_users_login to fix it.Tara Kizeraka tduggan |
|
|
|
|
|
|
Where's user/login mapping utility?