Wednesday, March 28, 2012
Install Problem...Please Help!
The event log provides me with: "Product: Microsoft SQL
Server Desktop Engine -- Installation operation failed.".
In close proximity to these error messages, I can see
some "LoadPerf" error messages and warnings. Seem these
messages are related.
Cool, another one of these "helpful" error messages.
I thried the 3rd party install and a manual install, but
to no avail.
Any idea, someone?
Best regards, Klaus
>--Original Message--
>A third party application is trying to install MSDE 2000
on our XP Professional machine. Install gets to about "2
seconds remaining" then backs out and simply quits. No
error messages. Saw a similar post on here but it was
never resolved. I've made sure the Server service is
running and that File and Print Sharing for Microsoft
Networks is installed and enabled. Any help would be
greatly appreciated...this is a very important application
we are trying to install. Thanks.
>Floyd
>.
>
hi Klaus,
"Klaus Stock" <ks@.expose-media.de> ha scritto nel messaggio
news:2d1201c47e2d$bf57b1c0$a401280a@.phx.gbl...
> Exactly the same problem here, on a W2K machine.
> The event log provides me with: "Product: Microsoft SQL
> Server Desktop Engine -- Installation operation failed.".
> In close proximity to these error messages, I can see
> some "LoadPerf" error messages and warnings. Seem these
> messages are related.
> Cool, another one of these "helpful" error messages.
> I thried the 3rd party install and a manual install, but
> to no avail.
please have a look if http://support.microsoft.com/?id=315083 can help
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
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