Re: import user list

From: Brian McCulloch (brian.d.mcculloch_at_citicorp.com)
Date: 07/22/04 

Date: Thu, 22 Jul 2004 12:20:08 -0700

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
>
>
>.
>

Relevant Pages

  • Re: Facing the same problem
    ... My stored procedure is being activated from a Service Broker ... remote server is denied because the current security context is not ... The linked server is a SQL server, but not one where I have any ... ALTER DATABASE db SET TRUSTWORTHY ...
    (microsoft.public.sqlserver.security)
  • RE: Calling stored procs on AS/400
    ... server is non-SQL Server. ... I assume that you are using DB2. ... Execute openquery to the DB2 linked server from SQL Server (e.g. insert ... If you use ADO or ADO.NET in code, you can execute the stored procedure on ...
    (microsoft.public.sqlserver.server)
  • Re: SQL/ADO (2.8) Timeout Error - Cant resolve
    ... > Server 2000 back end. ... > timeout limit. ... And I’ve used SQL Query Analyzer to run the ... I am running a stored procedure that will backup a SQL Server ...
    (microsoft.public.sqlserver.clients)
  • Re: How to test a custom conflict resolver procedure
    ... once I set my stored procedure as a custom resolver? ... Here is an example of a custom resolver I wrote which might help you ... --creating the stored procedure conflict resolver ... Looking for a SQL Server replication book? ...
    (microsoft.public.sqlserver.replication)
  • Re: What needs to be set up to use the xp_sendmail Stored Procedure?
    ... You can use an extended stored procedure that just uses SMTP, ... I installed Outlook 2000 on the SQL Server. ...
    (microsoft.public.sqlserver.setup)