Coping logins from one server to other

Hello All,
How Can I copy logins from one server to another?
Any help will be appreciated.
Regards,
Miguel.You should check out xp_help_revlogin. Here is an article that should help
you out: http://databasejournal.com/features/mssql/article.php/2228611
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"Miguel Ramirez" <miguel.ramirez@.valycontrol.com.mx> wrote in message
news:ekiGfgOSEHA.3944@.tk2msftngp13.phx.gbl...
> Hello All,
> How Can I copy logins from one server to another?
> Any help will be appreciated.
> Regards,
> Miguel.
>

Converting MS ACCESS db to SQLExpress

Is it possible to convert an ms access mdb file to an sqlexpress mdf file?
Any help appreciated,
Henk Feijt

You cannot convert MDB to MDF because MDF(microsoft data file) is only half of a SQL Server database because you also have the LDF(log data file). Create the database in Express and do a INSERT INTO or download the eval version of the full SQL Server 2005 and install the OLTP(online transaction processing) management studio which is a separate install under management tools and use integration services which is the new DTS to import the database from Access. BTW Access was not relational untill version 2000. Hope this helps.
http://www.microsoft.com/sql/downloads/trial-software.mspx|||Thanks for your info. But I find out that you can convert mdb to mdf. Access 2000 has an upsize wizard that convert the mdb to adf or mdf.
|||MDB to MDF
You will not belive that, but just trycopy(content of table from SHOW TABLE DATA)and paste(to prepared target table with same structure as the source)!
First you have to connect MDB ACCESS as datasource to the database explorer.
I Was spend almost two days on hard trying to conect and do SELECT INTO....
but it's so trivial to import data into the SQLExpress without sophisticated tools!