Search results for query: *

I am attempting to rebuild the master database in a SQL Server 7.0 database environment. I keep getting a sharing violation error and am not sure what it hanging on to the file. Error: Cannot copy Master, there has been a sharing violation. Any ideas on what may be holding onto the file...

During the importation of a large number of records(1,495,000) on SQL Server 2000 to a table from a flat delimited file, a error is encountered when the import approaches 1,400,000. Error: Seek failed on an unnamed file. If we delete the top or bottom 400,000 records, the import works fine...

I am currently working on restoring a backup to Oracle 9i version 1. I did not see a forum for 9i so thought I would post here. We have the management server setup and are logged in. However, when we try and restore via the wizard, it is telling us we need to select a target database...

My apologies. I will get the exact motherboard version, CPU version etc...as soon as I get home from work. Thanks for the tips as well. I do know it is an AMD +1800 processor with a KTI VT100 motherboard if that helps any.

Thanks for the replys. I am unable to boot into safemode as well. I will try and clear the CMOS but am a little unclear on how to do this and do not know the implications.

After leaving my desktop on for about an hour and then coming back, I was faced with a lockup after I tried to log back in. Currently using XP Home. I rebooted after the lockup and now I am faced with a "unlock keyboard" prompt anytime I reboot. I am unable to get to Windows at all...

That does help, thank you very much.

I know 9i has the MERGE statement but was looking for a way to do this with 8i. To take a source table and compare to a destination table, if the data is different or new to update the destination table.

CREATE TRIGGER DResolved ON HEAT.Asgnmnt FOR INSERT, UPDATE AS \\I need to perform the actions of the trigger only if the value for DateResolve is empty. Ie..IF (select DateResolv from Asgnmnt a JOIN Inserted i ON a.HEATSeq = i.HEATSeq) = 'NULL' BEGIN Update Asgnmnt set DateResolv = (select...

That worked perfectly. Thank you very much for the assistance. Kelin

I am trying to update the current record a user is working on via a trigger but it is updating all of the records since I cannot designate the actual record in the trigger. CREATE TRIGGER TimeDate ON dbo.Asgnmnt FOR INSERT, UPDATE, DELETE AS Update Asgnmnt set TimeAssign = (select...