Showing posts with label return. Show all posts
Showing posts with label return. Show all posts

Monday, March 12, 2012

Instalation MSDE failled !

Hello,
I'm trying to install MSDE but it fails.
I notice thatthe install log has several return values 3 wich means
problems.
...
Starting custom action InstallSQLAgentSecurity
InstallSQLAgentSecurity failed (AHFTSH,LocalSystem,87).
Action ended 11:25:35: InstallFinalize. Return value 3.
...
Start custom action DeferProperties
Defer Properties returns: 0
MSI (s) (48:B4) [11:25:40:093]: Executing op:
End(Checksum=0,ProgressTotalHDWord=0,ProgressTotal LDWord=0)
MSI (s) (48:B4) [11:25:40:093]: Error in rollback skipped. Return: 5
MSI (s) (48:B4) [11:25:40:109]: Calling SRSetRestorePoint API.
dwRestorePtType: 13, dwEventType: 103, llSequenceNumber: 246, szDescription:
"".
MSI (s) (48:B4) [11:25:40:171]: The call to SRSetRestorePoint API succeeded.
Returned status: 0.
MSI (s) (48:B4) [11:25:40:171]: Unlocking Server
MSI (s) (48:B4) [11:25:40:171]: PROPERTY CHANGE: Deleting UpdateStarted
property. Its current value is '1'.
Action ended 11:25:40: INSTALL. Return value 3.
...
MSI (s) (48:B4) [11:25:40:328]: MainEngineThread is returning 1603
MSI (s) (48:94) [11:25:40:328]: Destroying RemoteAPI object.
MSI (s) (48:30) [11:25:40:328]: Custom Action Manager thread ending.
MSI (c) (28:3C) [11:25:40:328]: Back from server. Return value: 1603
MSI (c) (28:3C) [11:25:40:328]: Decrementing counter to disable shutdown. If
counter >= 0, shutdown will be denied. Counter after decrement: -1
Action ended 11:25:40: INSTALL. Return value 3.
...
=== Logging stopped: 21-11-2007 11:25:40 ===
MSI (c) (28:3C) [11:25:40:359]: Note: 1: 1708
MSI (c) (28:3C) [11:25:40:359]: Product: Microsoft SQL Server Desktop
Engine -- Installation operation failed.
MSI (c) (28:3C) [11:25:40:375]: Grabbed execution mutex.
MSI (c) (28:3C) [11:25:40:375]: Cleaning up uninstalled install packages, if
any exist
MSI (c) (28:3C) [11:25:40:375]: MainEngineThread is returning 1603
=== Verbose logging stopped: 21-11-2007 11:25:40 ===
Solutions ?
Regards
Antonio Ferreiar
Andrea,
Thanks. Problem solved.
Antonio
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> escreveu na mensagem
news:5qj194F10cgomU1@.mid.individual.net...
> hi Antonio,
> Antonio Ferreira wrote:
> have you already seen http://support.microsoft.com/kb/829386/en-us ?
> regards
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz http://italy.mvps.org
> DbaMgr2k ver 0.21.0 - DbaMgr ver 0.65.0 and further SQL Tools
> -- remove DMO to reply
>

Wednesday, March 7, 2012

Inserting, updating Record having Single, double quotes.

Hi all
I need to insert some text in a table that contains single as well as double
quotes but its return error during inserting or updating.
I converted single as well as double quote to chr(39) and chr(34) but still
facing problem.
Please advise how I can solve it.
Kind RegardsFor double quotes, check if you have SET QUOTED_IDENTIFIER ON; single
quotes hae simply to be duplicated iside the string. Example:
USE tempdb
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE T1
(a varchar(50))
GO
INSERT INTO T1 VALUES ('A single '' apostrophe; and a double " one')
SELECT * FROM T1
DROP TABLE T1
GO
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"F@.yy@.Z" <fayyaz.ahmed@.mvwebmaker.com> wrote in message
news:e68qySBuEHA.1308@.tk2msftngp13.phx.gbl...
> Hi all
> I need to insert some text in a table that contains single as well as
double
> quotes but its return error during inserting or updating.
> I converted single as well as double quote to chr(39) and chr(34) but
still
> facing problem.
> Please advise how I can solve it.
> Kind Regards
>
>
>

Inserting, updating Record having Single, double quotes.

Hi all
I need to insert some text in a table that contains single as well as double
quotes but its return error during inserting or updating.
I converted single as well as double quote to chr(39) and chr(34) but still
facing problem.
Please advise how I can solve it.
Kind RegardsFor double quotes, check if you have SET QUOTED_IDENTIFIER ON; single
quotes hae simply to be duplicated iside the string. Example:
USE tempdb
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE T1
(a varchar(50))
GO
INSERT INTO T1 VALUES ('A single '' apostrophe; and a double " one')
SELECT * FROM T1
DROP TABLE T1
GO
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"F@.yy@.Z" <fayyaz.ahmed@.mvwebmaker.com> wrote in message
news:e68qySBuEHA.1308@.tk2msftngp13.phx.gbl...
> Hi all
> I need to insert some text in a table that contains single as well as
double
> quotes but its return error during inserting or updating.
> I converted single as well as double quote to chr(39) and chr(34) but
still
> facing problem.
> Please advise how I can solve it.
> Kind Regards
>
>
>

Inserting, updating Record having Single, double quotes.

Hi all
I need to insert some text in a table that contains single as well as double
quotes but its return error during inserting or updating.
I converted single as well as double quote to chr(39) and chr(34) but still
facing problem.
Please advise how I can solve it.
Kind Regards
For double quotes, check if you have SET QUOTED_IDENTIFIER ON; single
quotes hae simply to be duplicated iside the string. Example:
USE tempdb
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE T1
(a varchar(50))
GO
INSERT INTO T1 VALUES ('A single '' apostrophe; and a double " one')
SELECT * FROM T1
DROP TABLE T1
GO
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"F@.yy@.Z" <fayyaz.ahmed@.mvwebmaker.com> wrote in message
news:e68qySBuEHA.1308@.tk2msftngp13.phx.gbl...
> Hi all
> I need to insert some text in a table that contains single as well as
double
> quotes but its return error during inserting or updating.
> I converted single as well as double quote to chr(39) and chr(34) but
still
> facing problem.
> Please advise how I can solve it.
> Kind Regards
>
>
>