I got the answer
AddNew will create a temp file as it will insert the data into a temp file before storing it into the main Database.If you are try to inseret the data in a sorted order or if your maintaing the Indexes it will generate teh huge tmp files.
So instead of AddNew just use Insert statment it will help you to insert the data directly in to the table where u want.
I'm getting an error calling a stored proc, and the error is about attempting to update a view, but I cannot find the location of the update, as the stored proc call calls other stored procs, etc. many, many levels deep. I've tried searching syscomments for all procs that contain the view name, and narrowed it down to nine procs, and thought I removed any updates from those procs, but I'm still getting the same error. Is there any other way to solve this rather than manual inspection?
Sorry, at the moment I don't really have any other suggestions. I've usually had pretty good luck with Profiler. Are you filtering anything out? Perhaps try saving the trace to a text file and searching that?
Why CTT*.tmp files are generating in %temp% while runing MySQL with ODBC connectivity.
The CTT*.tmp are growing in size as records are growing.
It is reaching upto 2GB.
Due to this my C drive is filling up and leading to crash.
Please help me out by telling what are CTT*.tmp files?
and why are they generated?
Anyone here successfully able to install SQL Server on Vista? I can't seem to install the Databae Engine component. Each time the install finishes, I can't find the service in SCM. Anyone been through the same experience?
(I have Windows Vista Enterprise SP1 and I am trying to install SQL Server 2005 Enterprise)
Every nation state's armed forces call themselves 'Defence',
makes me wonder why there are conflicts in the world.
Hmm - unfortunately I can't give you other help then yes - I've installed SQL Server (developer edition) on my Vista (x64).
I did not have any such problems as you mention - but I do recall there was a large service pack (for SQL Server 2005 for Vista.
Don't know if that might be the way to go
id sid subid marks
1 1 1 100
2 1 2 100
3 2 1 100
My question is what shall be the query for those students who did not appear in all exams
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!