October 18, 2010 at 11:15 pm
Can it possible to export or list of all users created in SQL server 2005. The requirement is i have one sql server 2005 installed on the Windows Server 2008 having 150+ users created. I wanted to have one more server as a backup and i wanted to have all the users which are created in the first server to be created in the second server. Is any way i can get the list of users created on the first server. These users are created over the period of time, so the documents are not avialble (physical). Is any way from the table or log can i get the list of users. The permission part and database mapping part and all i can manage.
If any one help me on this will very helpful.
REgards
Srini
October 19, 2010 at 10:45 pm
Hi Srini,
Does this give you what you need?
select name from master.sys.syslogins
Jenny
October 19, 2010 at 11:02 pm
Yes. This is what i was looking for. Thank you. If i need anything more i will come back to you. Once again thank you.
Basically, i wanted to have to sql server with the same setup. The data will get replicated but about the logins i was not able to replicate. i will have to note all the login details manuallly which will be a very lenghty process.
is any other way can i copy / replicate the users into the second server.
Regards
Srini
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply