Showing posts with label click. Show all posts
Showing posts with label click. Show all posts

Friday, March 23, 2012

install intialization error

I am trying to install SQL Server 2000 on my Win2k pc. I double-click the cd, click SQL Server 2000 Components, Install Database Server, then I get an error message:

Error
Setup intialization error.
Error performing inpage operation.

Source: 'D:\x86\setup\...\Binn\Res\1033\purgeset.rll'
Target: 'C:\WINNT\TEMP\SqlSetup\Bin\purgeset.rll'

I tried rebooting, and it still does not work. Any ideas?Which edition of SQL used and is it a server edition of win2K?

Previously I found this error is caused due to bad media, if possible can you copy it to the local disk and try to install.

KBA - http://support.microsoft.com/?kbid=141117 explain about such errors on OS./

Sunday, February 19, 2012

INSERTING or UPDATING automatically

i am using visual web developer 2005 and SQL Express 2005 with VB as the code behind

i have a button and in the button click event i have written codes to INSERT to a database table - it has one primary key

so when i click the button, if there is already a row with primary key fields value as 10 and if i try to INSERT with the same value in the primary key field there will occur primary key constraint

so , if i try to INSERT with the already existing primary key fields value, instead of INSERTing it should be UPDATEd without generating any error

please help me

In ur SQl procedure

Include


If exists (select [PrimaryKeyColumn] from UrTable where PrimarKey = @.PrimaryKey)

Update ...

else

Insert ...

Like this u get to check for existing key , if exists it will execute an update else an insert

Hope that helps u