Re: import user list

From: Steve Thompson (stevethompson_at_nomail.please)
Date: 07/23/04 

Date: Fri, 23 Jul 2004 13:12:17 -0400

Excellent!

"Brian McCulloch" <brian.d.mcculloch@citicorp.com> wrote in message
news:235901c47020$e6cbb230$a401280a@phx.gbl...
> Many thanks. I had to use the stored procedure method
> since my SQL server is set up under local and can't
> tranfer files. Worked beautifully, though. Only took about
> 5 minutes start to end.
>
> Thanks again.
>
> Brian.
> >-----Original Message-----
> >"Brian McCulloch" <brian.d.mcculloch@citicorp.com> wrote
> in message
> >news:236a01c4700c$a22811f0$a301280a@phx.gbl...
> >> I'm importing a database from SQL 7 to 2000. The import
> >> fails partway through because I don't have all the users
> >> set up on the 2000 server. I don't see a way to import
> the
> >> users from 7. I can export them to a file, however. Is
> >> there a way to use that file to get them into the 2000
> >> server? I'm sure I could import the data and write code
> to
> >> use existing stored procedures but I'm hoping to avoid
> re-
> >> inventing the wheel as I'm fairly confident I'm not the
> >> only one who's run into this problem.
> >
> >See if this helps you, there are several ways to transfer
> user accounts,
> >without having to script the whole process yourself:
> >http://support.microsoft.com/default.aspx?scid=kb;en-
> us;246133&Product=sql2k
> >
> >Steve
> >
> >
> >.
> >