Recent content by gbraden

My friend, who has a Compaq she barely knows how to use, asked me to do a scan of her Windows XP Home and install an anti-virus for her. I downloaded Kaspersky Rescue disk, dated 05/13/2011 and created a bootable disk from the ISO file. I successfully booted it up, and ran a scan against the C...

okay, solution for #3 (in psuedo code) would be to add column VacantSeats to the tblTasking. VacantSeats is a calculated field where [no of seats - (select count(taskID) from table Assignment)] Thanks PH for the help! [noevil] Glen Braden

OKAY, as I see it (after viewing the tutorial), I need to connect Member table to a new table (table assignment) where memberID is linked to taskID from the Tasking table. The seat table contains a seatID and other information (such as seat usage). The Task table is connected to the seat table...

How about VMware? Of course we are not going to use Hyper-V, but instead, create/colapse several servers on our 2008 server using VWware. Does anyone know of any gotchas? [noevil] Glen Braden

Correction to the problem. A Member can have more than one TASK, The task can have more than one seat, but the member can only be assigned one seat from any giving task. [noevil] Glen Braden

Hi all, I am not very good with creating databases and how they need to work to get what I need. I tend to over-do it and make things far more complicated. I don't need code, I need to get a picture in my head how to hook up several elements. Of course, this is needed yesterday, which I cannot...

Thanks for all your input. The new drive was okay when I hooked it into another computer. The old drive, when hooked into the second computer will cause a new hardware found, but I cannot get it recognized as a drive in any flavor (storage, slave, etc). I do wish I waited and ran bootable linux...

The drive is the same make, original being 38G IDE and the new being 250G eIDE. The hard drive is original and the PC was perchased in 1999. While it is silly not to get a new one (at today's prices), my wife who uses the machine for email and facebook, doesn't want me to spend the money on a...

I have an old Gateway, got the SMART failure, could not bypass the error so I replaced the hard drive, formatted the drive, reloaded the OS and apps, restarted computer and while loading a couple more drivers got the SMART failure again. What am I missing? Is it possible that something on the...

Please disregard... I got some bad information! [shadessad] [noevil] Glen Braden

As I understand it from another DBA, that I cannot upgrade SQL Server 2005 Express SP2 to SP3 because the Express SP3 package is a complete database package and running it would only install/create a new instance. I also understand that moving the stuff from SP2 to the new SP3 is troublesome...

Hi everyone, I spent the last two days going through a long list, looking about for descriptions of undocumented SP/XP procedures (USP). I managed to find rudamentry descriptions for about 85%. This is for a security plan required by my organization. If anyone uses any of the following USPs...

Quick question. One of the DBA has a SQL Agent Job that runs on weekends that looks at indexes, and if there is 30% or more fragmentation, the indexes are dropped and recreated. On the other hand, as I explore the various issues we have with performance, I am seeing articles that indicate...

Final solution: I decided to return the 64-bit machine. Instead I will clone his old drive to a new drive to solve any issue of his old hard drive crashing. After, I will build him a 32-bit turn-key system from scratch. I go a lot of good information here (and elsewhere)! [noevil] Glen Braden

HP had (good) instructions for the model PC to 'downgrade' to Windows XP. They do warn that doing so might void the warranty. There were no drivers on the site for windows XP compatibility. The instructions did not address it either. I would image the new environment before I go off...