You cannot change the SA password in Microsoft SQL server like you do a users password.
To change the SA password you need to run the following command from a DOS prompt.
You will of course need to have some sort of SQL client installed.
C:> OSQL -E -S -dmaster -n -iC:\temp\sa.sql
where sa.sql contains
sp_password @new = 'will_never_forget_again', @loginame = 'sa'
> From http://vyaskn.tripod.com/administration_faq.htm#q9
I often use Microsoft Excel at work to collate data. One feature I’ve always had trouble with is the freeze funtion.
I could never seem to get it to freeze the columns/rows i wanted to. So the other day i sat down and tried to work it out.
- To lock rows, select the row below where you want the split to appear.
- To lock columns, select the column to the right of where you want the split to appear.
- To lock both rows and columns, click the cell below and to the right of where you want the split to appear.
I kind of like using Window Photo Gallery in Windows Vista. Its a nice way to display and browse my photos.
But recently I moved my photo collection and Photo Gallery “lost” most the photos.
There didn’t appear to a way to delete a photo from the gallery without deleting it from the disk as well.
After some searching I found that what you have to do is delete or rename the file
C:\Users\[username]\AppData\Local\Microsoft Windows Photo Gallery\Pictures.pd4
via deleting photos in windows photo gallery – Vista Forums.
I’m trying to build an Oracle RAC system at work to understand how it works better. As part of this I had to build three Linux systems. I built one, then cloned it (it was a virtual machine in VMware).
But having done that, it of course kept the hostname of the first machine. So I had to work out how to change that.
It turns out that is quite easy.
- Edit file /etc/sysconfig/network using your favourite editor. In my case is nano.
- Look for HOSTNAME=xxxxxx
- Change the xxxx to the name you wish to set for your computer.
- Save the file and restart the xinetd service. (eg. type service xinetd restart in your shell)
Or simply reboot.
via How to change hostname in Linux – Techie Corner.
I had to use the following step to reset a the root password on a Solaris system the other day. You will need physical access to the system to use these steps.
- Press Stop-A on the console or Ctrl-] and send brk from a remote console connection to access the Open Boot PROM (OBP).
NOTE : If you are using TeraTerm-Pro, you send a break from the menu.
- Insert a bootable Solaris CD/DVD and boot into single-user mode with boot cdrom -s
If a JumpStart boot server is located on the system’s subnet, and the system was properly configured for JumpStart, you may instead boot over the network into single-user mode with boot net -s
- Make a mount point within the /tmp file system by typing mkdir /tmp/mnt
- Mount the root partition of your boot disk in /tmp/mnt
e.g. #> mount /dev/dsk/c0t0d0s0 /tmp/mnt
NOTE : To check the device name use the format command.
- Edit /etc/shadow with TERM=vt100 vi /tmp/mnt/etc/shadow
- Remove the encrypted part of the root password (the second field; fields are separated by colons), save, and exit.
- Unmount the file system with umount /tmp/mnt
- Reboot the system and assign a new password at a shell prompt with the passwd command.
If you are unable to run vi above, you can edit /etc/shadow using the ed editor.
# ed /tmp/mnt/etc/shadow
s/:………….:/::/ (Note: there are 13 dots in the second field)