I have restored one db of one instance from uat to anthother dev instance of the same server but how to fix orphan users I got 106  users how to fix and how to create logins is there any script for this scenario
123272
It's fairly straight forward to fix up a single orphaned SQL user to a login using:     EXEC sp_change_users_login 'Auto_Fix', 'user'   I could script this, but is there an existing stored procedure which automatically tries to fix up every orphaned user in a given database?
28203
Hi I've stumbled into the administration of a Legacy SQL 2000 server that has had next to no maintenance for the past 8 years (and is very slow).  As I have only been doing DBA / PT for the past 2 years (I'm primarily a Developer) I don't have allot of experience on 2000.  Can anyone point me in the direction of some maintenance, tuning scripts.  Just figured I'd ask first before I reinvent the wheel for something I will rarely use.  Thanks Guys / Girls !
76842
I want to make it so I always have 50 entities in an area. So when 1 dies/despawns/leaves the area I want it to detect that and summon in a new entity, and yes I do want them to die/despawn/leave the area so preventing those things is not an option.
35996
I have a total of three machines. I have installed MaaS in one of my machines and the other two machines were added to the MaaS nodes list and kept in ready state.  When I run the fourth step given in the  Ubuntu documentation, both the machines went to the deployed state.  Both the nodes in the deployed state are asking for login and password, and the Ubuntu OpenStack installer screen is running for too long a time. I don't know to how to proceed. Please help me. I am looking for this to do simple job scheduling in a cloud environment using OpenStack.
39784
Unsolved mystery - I was given a coworker's Ubuntu 12.04.1 LTS machine and set up my own (sudo/admin) user on there from the command line. I switched to my user (from his sudo/admin user) and confirmed everything was okay using the groups command and the /etc/passwd file looked great. After months of everything working perfectly, a power outage shut down the machine for the first time since I inherited it.  After booting, my new user disappeared. It's not in the /etc/passwd file and there is no entry in the /home directory. I created the user the same as I did before, and there were no errors to indicate that the user still existed.  What happened?  As requested, here is the output of   olduser@machine:~$ ls -lait /home  total 16  3408126 drwxr-xr-x 2 newuser newuser 4096 Nov 20 10:28 newuser  3407873 drwxr-xr-x 4 root root 4096 Nov 20 10:28 .  3407874 drwxr-xr-x 36 coworker coworker 4096 Nov 20 10:00 bvillupu  2 drwxr-xr-x 26 root root 4096 Oct 3 2012 ..  3408259 lrwxrwxrwx 1 root root 44 Aug 9 2012 .directory -&gt; /etc/kubuntu-default-settings/directory-home
96957
When I set up Ubuntu system for the first time, and create first user, will that user be root? I would like to use sudo user, so how to add it if first user is root? Also is it possible to create sudo user withoute root user?
69435
Help! My master database is corrupt, I can't even bring the SQL instance online! What are my options to get my server back up?   I do have a backup of master, but the  asks me to start the instance in single-user mode, which I can't do!  (Note: I'm leaving this question unspecified as to SQL version, so as to be a more widely-applicable reference. There are some similar questions on DBA.SE, but none that involve the server unable to start.)
14565
My reputation rating on SO took this hit an hour ago, and it is due to what appears to be the simultaneous deletion of multiple questions.  I am uncertain why it happened, am concerned, and would appreciate an explanation.  Going to  shows that it was removed due to moderation.  Was a script run deliberately, or were we hit with a question deletion attack; what happened?  -12     today -2  1 hour ago  removed     How to send a 2d Vector over UDP in c++ -2  1 hour ago  removed     How do I use the Eclipse debugger to debug a Java application? -2  1 hour ago  removed     PHP string error; inconsistency with local and server -2  1 hour ago  removed     Unable to start the MySQL service after a server migration -2  1 hour ago  removed     How to use Java to print a text file on a ticket printer? -2  1 hour ago  removed     How can all of the ZBrush Obj files be imported to make a complete model?
3846
In the past there has been sudo /etc/init.d/mysql reset-password, (1) is manually restarting and setting the password with an sql command again required? (2)  (1)  (2)
77289
Since upgrading my user's crontab has been wiped out. This is not the first time this has happened this year and it's a pain restoring it each time.  I'd like to be able to back up the crontab for my user but for that I need to know where it's stored.
104197
When i create new User Account and login with that credentials, it gives me this problem if admin doesnt have set thier values yet !!!**  AllotmentList = [select id, Days_Remaining__c from PTO_Allotment__c where Year__c =:year and Employee__c=:EmployeeList[0].id LIMIT 100]; //access only Current user Allotment details                 //to handle Listoutof Bound Exception wrote if-else          if(AllotmentList.size()&gt;0)         {         requests.PTO_Allotment__c=AllotmentList[0].id;         requests.Days_Remaining__c=AllotmentList[0].Days_Remaining__c;         }         else         {             //write a code when AllotmentList is empty ....         }
97177
Something has changed in server 16.04 LTS, I can't find tty1, but I need to make an auto-login on tty1 (in console mode), in 14.04 LTS I can make this work.  I can't find /etc/init/tty1.conf  How to, or a link?
85133
A searched for answers but have found nothing on here...  Long story short: a non-profit organization is in dire need of modernizing its infrastructure. First thing is to find an alternatives to managing user accounts on a number of Linux hosts.  We have 12 servers (both physical and virtual) and about 50 workstations. We have 500 potential users for these systems. The individual who built and maintained the systems over the years has retired. He wrote his own scripts to manage it all. It still works. No complaints there. However, a lot of the stuff is very manual and error-prone. Code is messy and after updates often needs to be tweaked. Worst part is there is little to no docs written. There are just a few ReadMe's and random notes which may or may not be relevant anymore. So maintenance has become a difficult task.   Currently accounts are managed via /etc/passwd on each system. Updates are distributed via cron scripts to correct systems as accounts are added on the "main" server. Some users have to have access to all systems (like a sysadmin account), others need access to shared servers, while others may need access to workstations or only a subset of those.  Is there a tool that can help us manage accounts that meets the following requirements?   Preferably open source (i.e. free as budget is VERY limited) mainstream (i.e. maintained) preferably has LDAP integration or could be made to interface with LDAP or AD service for user authentication (will be needed in the near future to integrate accounts with other offices) user management (adding, expiring, removing, lockout, etc) allows to manage what systems (or group of systems) each user has access to  - not all users are allowed on all systems support for user accounts that could have different homedirs and mounts available depending on what system they are logged into. For example   sysadmin logged into "main" server has main://home/sysadmin/ as  homedir and has all shared mounts  sysadmin logged into staff workstations would have nas://user/s/sysadmin as homedir(different from above) and potentially limited set of mounts, a logged in client would have his/her homedir at different location and no shared mounts.   If there is an easy management interface that would be awesome. And if this tool is cross-platform (Linux / MacOS / *nix), that will be a miracle!   I have searched the web and so have found nothing suitable. We are open to any suggestions. Thank you.  EDIT: This question has been incorrectly marked as a duplicate. The linked to answer only talks about having same homedirs on all systems, whereas we need to have different homedirs based on what system user is currently logged into(MULTIPLE homedirs). Also access needs to be granted only to some machinees not the whole lot. Mods, please understand the full extent of the problem instead of merely marking it as duplicate for points...
51691
My server is just ridiculous sometimes. So I have looked intensively into another server and things are quite better there. So I have 2 higher level characters (55, 30+) on this server. What happens to my legacy if I transfer only one of them and the other one later?  Will my legacy stay on the original server? What will happen there?
70009
I ran into this error earlier today and requested that the extra logs be purged from the server. It was done but it still claims that there isn't any room. Is there a way to notify the server that it has more room than it thinks?
73026
I have an Ubuntu 11.10 system with 2 users:   The first was created during the installation The second instead was created after. It belongs to the sudoers group.   Now the problem is that when the second tries to use a device ttyUSB0 the following error is returned:  "Could not open serial port /dev/ttyUSB0"   I was able to fix it by using:  sudo chown :second_user /dev/ttyUSB0   However when I disconnect the device and reconnect it the problem comes back.  Is there a way to allow different users to access the devices? I suppose I have to add the user to a specific group. Currently the owner is root and the group is dialout. However I'm not sure about the group and I don't know how to add the user.  Thanks!
46394
If there a way to protect against concurrent modifications of the same data base entry by two or more users?  It would be acceptable to show an error message to the user performing the second commit/save operation, but data should not be silently overwritten.  I think locking the entry is not an option, as a user might use the "Back" button or simply close his browser, leaving the lock for ever.