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 |
|
dbthj
Posting Yak Master
143 Posts |
 Posted - 2008-05-01 : 14:28:31
|
| I have versions of sp_hexadecimal and sp_help_revlogin I used with SQL 2000 to transfer logins. Will they work with SQL 2005 as-is? Might I need updated versions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-01 : 14:40:04
|
http://support.microsoft.com/kb/246133quote:
APPLIES TO• Microsoft SQL Server 7.0 Standard Edition • Microsoft SQL Server 2000 Personal Edition • Microsoft SQL Server 2000 Standard Edition • Microsoft SQL Server 2000 Workgroup Edition • Microsoft SQL Server 2000 Developer Edition • Microsoft SQL Server 2000 Enterprise Edition • Microsoft SQL Server 2005 Standard Edition • Microsoft SQL Server 2005 Workgroup Edition • Microsoft SQL Server 2005 Developer Edition • Microsoft SQL Server 2005 Enterprise Edition
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-01 : 16:02:17
|
| If from 2000 to 2005, then remember exec sp_help_revlogin_2000_to_2005 @login_name=NULL, @include_db=1, @include_role=1GO |
|
|
|
|
|
|
Transfer Logins with Passwords and SQL2005