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 |
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
 Posted - 2009-01-14 : 16:31:23
|
| Can you please provide me the sql script for copying the security logins from sql server 2000 to sql server 2005 servers.Thanks! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-14 : 17:24:49
|
| Did you search for it? |
 |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2009-01-14 : 21:28:10
|
| http://support.microsoft.com/kb/246133 |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2009-01-15 : 10:54:39
|
| Thanks for the reply, I am going thru the script, actually I need to transfer the logins from sql 2000 to sql 2008, can I use this script for doing that? Thanks!! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 10:59:50
|
| No, you can't.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111431 |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2009-01-15 : 11:21:43
|
| Thanks for the quick reply, that script is awesome! Before running the script, I want to confirm the following as my source is production server(sql 2000):1. shall I run the script in the source sql 2000 db?2. After getting the output, I need to run that output in sql 2008?Thanks!! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 11:24:34
|
| I am not sure about SQL 2000 but it works great from SQL 2005 to SQL 2008. |
|
|
|
sqlserverdeveloper
Posting Yak Master
243 Posts |
Posted - 2009-01-15 : 11:39:32
|
| I shall try running the script in sql 2000 server, could you please confirm the below questions:1. shall I run the script in the source sql 2000 db?2. After getting the output, I need to run that output in sql 2008?Thanks!! |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-15 : 11:47:51
|
| It won't run in SQL 2000. |
|
|
|
|
|
|
sql script for moving logins