x

Can SQL Server 2000 replicate system databases and/or logins?

Can SQL Replication be used to publish SQL Server 2000 system databases to another SQL Server 2000 server, i.e master, model, msdb?

If this is not possible, what is the correct strategy for keeping SQL Logins synchronised (more specifically their passwords) between a publishing server and a subscriber?

more ▼

asked Apr 28, 2010 at 09:28 AM in Default

avatar image

Kev
15 6 6 8

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You can use DTS, T-SQL scripting or manual processes.

One of the foremost articles on transferring logins is here.

more ▼

answered Apr 28, 2010 at 09:40 AM

avatar image

Blackhawk-17
12k 30 35 42

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x501
x414
x364

asked: Apr 28, 2010 at 09:28 AM

Seen: 4508 times

Last Updated: Apr 28, 2010 at 09:28 AM

Copyright 2016 Redgate Software. Privacy Policy