I just install new server for testing only. I have problem about user in
master database. How to copy all user from production server to testing
server?Are you referring to users in the master database or logins? Also, what vers
ion of SQL Server?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:A01991A7-16F8-4E16-BC3F-EA21842E8011@.microsoft.com...
>I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||Hi
I assume you are meaning logins rather than users which can be scripted. To
transfer logins check out http://support.microsoft.com/kb/246133/
John
"Mesak" wrote:
> I just install new server for testing only. I have problem about user in
> master database. How to copy all user from production server to testing
> server?|||If I have backup site (another building). I test system at backup site one
time per year. Do you have any solution to copy login to new server at backu
p
site?
Thank you.
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I assume you are meaning logins rather than users which can be scripted. T
o
> transfer logins check out http://support.microsoft.com/kb/246133/
> John
> "Mesak" wrote:
>|||Hi,
Use the below URL:
http://www.databasejournal.com/feat...cle.php/2228611
Thanks
Hari
SQL Server MVP
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at
> backup
> site?
> Thank you.
> "John Bell" wrote:
>|||The solution to copy login is in the URL that John posted:
http://support.microsoft.com/kb/246133
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Mesak" <Mesak@.discussions.microsoft.com> wrote in message
news:B4198F70-AAEC-4B94-921E-602D2ACF2D9C@.microsoft.com...[vbcol=seagreen]
> If I have backup site (another building). I test system at backup site one
> time per year. Do you have any solution to copy login to new server at bac
kup
> site?
> Thank you.
> "John Bell" wrote:
>
No comments:
Post a Comment