Re: Exporting SQL users
From: James Luetkehoelter (james.luetkehoetler_at_NOSPAMspyglassllc.com)
Date: 07/28/03
- Next message: Ray Higdon: "Exporting SQL users"
- Previous message: TIm: "Exporting SQL users"
- In reply to: TIm: "Exporting SQL users"
- Next in thread: Ray Higdon: "Exporting SQL users"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 28 Jul 2003 11:04:51 -0500
Yes, you can generate a SQL script to recreate them. In Enterprise Manager
ight click on any database and select Generate SQL Script. Go to the
options tab and select "Script SQL Server Logins". Go back to the general
tab and hit Preview (or just hit OK for it to generate the file).
"TIm" <tim.s.horrocks@intel.com> wrote in message
news:091e01c35520$c22b06e0$a401280a@phx.gbl...
> Is there a way to export all the sql users from one
> server (SQL2K) and import them on another? Thanks!
- Next message: Ray Higdon: "Exporting SQL users"
- Previous message: TIm: "Exporting SQL users"
- In reply to: TIm: "Exporting SQL users"
- Next in thread: Ray Higdon: "Exporting SQL users"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
