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 |
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-11-01 : 07:39:33
|
| Hi allIm currently on a client now..can anyone please tell me how to migrate all users,security and roles as well to a new sql.Its sql 2000 server they moving to the new box stil sql 2000.please help! |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-01 : 09:38:02
|
| Did you search in so called machine google? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-01 : 12:07:44
|
| use transfer database objects task available in DTShttp://technet.microsoft.com/en-us/library/aa933513(SQL.80).aspx |
 |
|
|
Zoma
Yak Posting Veteran
76 Posts |
Posted - 2008-11-03 : 04:08:12
|
quote: Originally posted by sodeep Did you search in so called machine google?
I always use google thats the first thing i did! |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-03 : 04:11:44
|
| did you check link i posted? |
 |
|
|
|
|
|