Is this done often, cause I wouldn't recommend it.

I understand why you would want to erase the temp tables if their consuming much space, but rather then trying to find...

We also need to know on which table you placed the trigger, I did a quick test and when I place the

UPDATE Consumables SET Quantity = U.Quantity + I.q1...

Yeah, I'm doing some tests on your problem.

And that didn't work, my excuse for this, I'm running a few tests on, it now.

First is the trigger on Inserted or on...

First you don't need the As, second try this

UPDATE Consumables SET Quantity = U.Quantity + Inserted.q1 FROM Consumables U INNER JOIN Inserted ON U.Product = Inserted.Product

Been resolved

DATAFILE 'D:\dbname\system01.dbf' SIZE 700M REUSE

I thought I did use reuse

I shutdown the database and removed the files to and replaced them with the files from the client,

Mounted the database succesfully...

Funny enough, the client now passed along that the database might be an 11 or 10g after all 🙁

Also found out that the name they gave me is not the...

OK I got a virtual Windows XP machine installed

Installed 9i

Created the dummy instance

Shutdown the dummy instance

After that I'm stuck

Yeah, got problems installing 9i

Its far from small the folder that contains the files tells me its 57.5 GB.

Problem is that I got no idea what the exact version of 9i there using.

I got...

Well I got the feeling compatibility might be a problem, I got word that the client still uses 9i

This isn't that hard few weeks ago I was confronted with the weirdest problem yet.

The hard disk that contained one of our non-critical databases had been removed by tech support...

I've been training to get 70-432 certification and came across this problem as well.

My personal opinion is that not only should you try and move tempdb to another location the...

I got the same problem on a SQL Server 2008, a general database failure (the files got deleted and the database was put offline by sql server at the same...

Txn for an answer but very late, already switched jobs twice since then.