Moving Users

How can I export users from one SQL 2000 server and
recreate them on another, maintaining the same
permissions they have on he first server without having
to do it manually?
Thanks
EmmaEmma,
Create a DTS Package using the Transfer Logins Task object.
Norman|||http://support.microsoft.com/defaul...kb;en-us;246133
Ray Higdon MCSE, MCDBA, CCNA
--
"Emma" <eeemoe@.hotmail.com> wrote in message
news:92fe01c3ea6c$f7ae51f0$a001280a@.phx.gbl...

quote:

---

> How can I export users from one SQL 2000 server and
> recreate them on another, maintaining the same
> permissions they have on he first server without having
> to do it manually?
> Thanks
> Emma

---

Moving Stored Procedures in SQL 6.5 to 2000

Hi All

How do I export/copy the stored procdures I have on SQL Server 6.5 to my new SQL 2000 installation?

Are there any big (or small) differences I need to know about between the two installations with regard to Stored Procedures?

Many Thanks

TaddubThe easiest way would be to script them from 6.5, you are probably going to have to change a fair amount to get them to perform well.

-Euansql

moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'de
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scripts/contributions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks

moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'de
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks
"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scri...utions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks
sql

moving sql to a new server

I just got a new server as the old server is too slow. What is the easiest
way to export the following to the new server:
1. Linked server configurations
2. Replication configuration
I read the Microsoft document called "HOW TO: Move Databases Between
Computers That Are Running SQL Server" but it does not discuss replication
information and linked servers. Right now the server is a publisher and I
have another box for the distributor and multiple boxes for subscribers. I'd
e
like to do the least amount of change on the replication and hope that there
is a way to restore the publisher databases on the new server (which has a
different name) and still have replication working.
Thanks"How to move SQL Server from one computer/server/machine to another"
http://vyaskn.tripod.com/moving_sql_server.htm
"Script out all linked/remote servers"
http://www.sqlservercentral.com/scr...butions/620.asp
Cristian Lefter, SQL Server MVP
"Anonymous" <Anonymous@.discussions.microsoft.com> wrote in message
news:979C3DDD-A9C9-486C-BAA3-5E00C94A3A1E@.microsoft.com...
>I just got a new server as the old server is too slow. What is the easiest
> way to export the following to the new server:
> 1. Linked server configurations
> 2. Replication configuration
> I read the Microsoft document called "HOW TO: Move Databases Between
> Computers That Are Running SQL Server" but it does not discuss replication
> information and linked servers. Right now the server is a publisher and I
> have another box for the distributor and multiple boxes for subscribers.
> I'de
> like to do the least amount of change on the replication and hope that
> there
> is a way to restore the publisher databases on the new server (which has a
> different name) and still have replication working.
> Thanks