Home Home    Forum    Blog    Feed your aggregator (RSS 2.0)

The Johnnynine Weblog - Tuesday, September 06, 2005
A weblog by Johnny Hughes
 
 Tuesday, September 06, 2005

You can not rename a SQL Server database from Enterprise Manager, but you can with the sp_renamedb stored procedure.  You must first set the database to singe user.

1. Set the database to Single User by right clicking the database in Enterprise Manager, select Properties, select the Options Tab, check the Restrict Access checkbox, and select Read-Only, then click OK.
2. Close Enterprise Manager (since we can only have 1 user accessing it at a time now).
3. Open Query Analyser.
4. Type:  sp_renamedb <oldname>, <newname>
5. Don't forget to reset the Restrict Access settings on the database that you changed in step 2.

Tuesday, September 06, 2005 5:31:19 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [5]   Database | Sql Server  | 
 Monday, August 08, 2005

WinZip allows you to scan your archive with a virus scanning tool.  Unfortunately it does not provide instructions on how to use Grisoft's AVG product.

When you receive a Zip file in e-mail or through other means, you should follow the same basic security procedures that you follow for any other file: use good virus scanning software, and know the source of the file. If you follow sensible security guidelines, you can be comfortable working with Zip files that you receive.

To enable virus scanning with AVG within WinZip:

1. Start Winzip in classic mode.
2. Select the Options -> Configuration... menu item.
3. Select the Program Locations tab.
4. In the Scan Program field, enter the path to the avgw.exe file.
    Mine was: C:\Program Files\Grisoft\AVG Free\avgw.exe
5. In the Parameters field, enter:  /se %d
6. Click OK.
7. To test it open a .zip file and select the Actions -> Virus Scan menu item.

Set your virus scanner to run a complete system scan on a schedule, and always scan files you download from the internet.

Tuesday, August 09, 2005 6:29:49 AM (US Mountain Standard Time, UTC-07:00)  #    Comments [0]   Technical  | 
 Friday, August 05, 2005

VMWare 4.5

Boot time: 1 min 40 sec.
CPU Usage: 1%
Network: Could not get the adapter drivers installed.
Usage is obviously slower than on a physical machine, but not too bad.

VPC2004

Boot time: 4 min 45 sec.
CPU Usage: 85%
Network: Worked fine.
Usage is so bad that I can see the Start Menu rendering when clicked on.


Conclusion:  If you really want to run Windows Vista Beta 1 in a virtual machine and don't care about the network adapter, I'd go with VMWare byfar.

Friday, August 05, 2005 8:37:52 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [0]   Technical  | 

I burned the ISO to a DVD+R but you can mount it to a drive letter on the host OS. (Virtual PC does not support ISO images over 2.2GB so the mount must be on the host OS.)

Create a new Virtual PC.  I used 256MB RAM and 16GB virtual hard drive.

Boot from the DVD or host os mounted image.

Click "Install Now".

Since the Windows Vista Beta 1 installer does not support RAW drives (ie. virtual hard drives) you must do the following:
See the Readme file for more details.  (However I was able to install it on VMWare without a problem.)

Press Shift-F10 to get a command prompt.  (I wasn't able to get Shift-F10 to work until after I selected "Install now".)

Type DISKPART at the command prompt to start the diskpart tool.

Type the following commands in diskpart:

select disk 0
create partition primary
select volume 1
format fs=ntfs label="windows vista"

Type EXIT to exit diskpart.

Reset the virtual pc via the Virtual PC Console window.

When you reboot an install, the partition will be ready to be selected.


Total install took 3 hours.  Compared to 1 hour with VMWare (see link). (I did use a little less memory in VPC, could that be why?)

Keywords:  Microsoft Virtual PC 2004 VPC2004 VPC 2004 Longhorn Microsoft Vista Beta 1 OS

Friday, August 05, 2005 6:38:26 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [0]   Fixes | Technical  | 

Do you remember spending countless hours on operating systems that are no longer around, or are at least no where to be seen?

I ran across this website a while back and thought I would share. :)

Welcome to guidebook, a website dedicated to preserving and showcasing Graphical User Interfaces, as well as various materials related to them.
Friday, August 05, 2005 6:01:50 PM (US Mountain Standard Time, UTC-07:00)  #    Comments [0]   General | Technical  | 
Copyright © 2009 Johnny Hughes. All rights reserved.
DasBlog 'Portal' theme by Johnny Hughes.