User details need to transfer

Question

Post reply

User details need to transfer

saidapur_satish

SSC Veteran

Points: 288
More actions
December 26, 2010 at 8:41 am

#388504

Hi,
I have doubt,
How do transfer /backup of user accout details ?
User Details :- User settings, login settings, etc...
Thanks & regards
Satish Saidapur

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply

Adiga One Orange Chip Points: 27284 More actions · Answer 1

You can make use of sp_help_revlogin

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 2

Which version to version ?

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

User info or login info?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

saidapur_satish SSC Veteran Points: 288 More actions · Answer 4

Hi,

User login one server to another server..... How do i do?

Thanks & Regards

Satish Saidapur

Marco V SSCrazy Points: 2939 More actions · Answer 5

saidapur_satish (12/29/2010)
Hi,
User login one server to another server..... How do i do?
Thanks & Regards
Satish Saidapur

roxette (sorry, first thing that came to mind, i know its: how do you do)

anyways the answer

http://support.microsoft.com/kb/246133

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

saidapur_satish (12/29/2010)
User login one server to another server..... How do i do?

Server-level login or database-level user? Which one?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

saidapur_satish SSC Veteran Points: 288 More actions · Answer 7

Hi Gail,

I need database level login......

Thanks & Regards

Satish Saidapur

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

There is no such thing as a database-level login.

Logins are server-wide, stored in the master database and allow connection to the server.

Users are stored per-database, mapped to logins and have the database-level permissions

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

saidapur_satish SSC Veteran Points: 288 More actions · Answer 9

Hi Gail,

Thank you, but what shall i do for test server user-login move to 2nd server databases....

Thanks & Regards

Satish Saidapur

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 10

If you've copied the databases over, the users will go along, they're in the DB, they're copied with the DB.

For the logins, the link Marco provided should give you what you need. Be sure to include the SID in the script, otherwise you'll have orphaned logins.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass