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...

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...

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...

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...