Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Other SQL Server 2008 Topics
 Strange events occuring

Author  Topic 

cenafan
Starting Member

2 Posts

Posted - 2009-05-29 : 10:07:16
Hello all.

I'm programming in VB Express 2008 and using SQL Server Express 2008. A while ago, I started getting an unexpected debugging error when trying to execute an INSERT command. I was, however, able to use CREATE TABLE, but not INSERT.

At first I thought this was a VB error, so I re-installed it, and still got the error. So then I tried to re-install SQL Server Express 2008, but upon installation, I received this error at the very end of the installation:

Internal Query Processing Error

And the installation fails. The only thing I can attribute to this failure is that I ran a couple adware and spyware cleaners just before the errors started occuring and I'm thinking one of them may have messed up something in the registry or an important Windows .dll, but I really have no other ideas at this point. I am using Windows XP SP2.

I'm no expert in SQL, so any detailed help would be greatly appreciated!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-05-30 : 03:22:06
you didnt give us any details on the error
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2009-05-30 : 05:53:30
and how does your insert statement look like?


E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

cenafan
Starting Member

2 Posts

Posted - 2009-06-01 : 15:21:38
There really are no more details to give, which is why it's so strange.

I've effectively eliminated the possibility of a coding error in VB.net because I made no alterations to the code before the INSERT command stopped working. The error at that point was considered by the debugger to be a "severe error" when dealing with the query. At which point I uninstalled SQL Express 2008 and re-installed it, only to get an Internal Query Processor Error at the very end of the installation.

Like I said, the only computer activity that I did was use an adware and spyware remover program. I'm thinking that it may have removed a critical Windows XP .dll or something, because re-installing SQL obviously was unsuccessful. Any ideas?
Go to Top of Page
   

- Advertisement -