Re: logins

Thanks, All I need to do is transfer to master.logins table


"Antonio Soto" <antoniosotorodriguez@xxxxxxxxx> wrote in message
news:uwyt2H3UGHA.4300@xxxxxxxxxxxxxxxxxxxxxxx
You can use many approaches:
- Copy Database Wizard
- A SQL 2000 DTS package
- A SQL 2005 SSIS package

Also you can use the following script
http://solidqualitylearning.com/blogs/antonio/archive/2006/02/25/1618.aspx

Regards


--
Antonio Soto
Solid Quality Learning
http://www.sqlu.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
"mecn" <mecn2002@xxxxxxxxx> escribió en el mensaje
news:umAey80UGHA.1688@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

How do I transfer all logins from sql2k server to a new sql2005 box?

Thanks





.

Relevant Pages

  • Re: Help with dtsrun and dts package.
    ... I dropped the tables from the database and that took care of the table ... The SQL server 2000 being used to create the dts package is on a different ... the MSDE master database but the message is that you cannot restore a SQL ... Can I create a dts package without using SQL 2000 Enterprise manager? ...
    (microsoft.public.sqlserver.odbc)
  • Re: Job Scheduler fails and Managing Tempdb
    ... You can turn logging on on both the job and the DTS Package to get some more ... As I said in my previous post, shrinking tempdb is not very useful. ... SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • DTS Package - Destination Server is now off of domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.dts)
  • DTS Package - Destination server is now off domain.
    ... The SQL Services were previously running as ... Now, my DTS package fails. ... - drop database DATABASENAME. ...
    (microsoft.public.sqlserver.security)
  • Problem using GLobal Variables in DTS Package
    ... I use SQL 2K on a Win2K box ... I have created a DTS package, the data source is a stored procedure with an ...
    (microsoft.public.sqlserver.dts)