Showing posts with label laptop. Show all posts
Showing posts with label laptop. Show all posts

Thursday, March 29, 2012

Error loading Query Execution Plan

I am trying to tune a very long running query (18 minutes on an Axim X51, 8secs on my laptop), but I can't get the query plan file that is generated on the device to load in the Sql Server Management Studio. I am using the Sql Everywhere CTP on the device, and version 9.00.2047 of the management studio shell.

FWIW, when I try to create the execution plan by running the same query on a .sdf file local on my laptop, I get a similar error trying to view the query plan.

Apart from the query plan issues, it would appear (just from the query execution time) that the indexes defined on the sdf file are not being used when executing the query on the device, but are being used when executing the query on the laptop. This is pure SWAG on my part, though.

I can't figure out how to attach a file to the post, unfortunately.

Thanks for any help you can offer.

Matthew Belk, BizSpeed, Inc.

Matthew,

What is the error that you get when loading the query execution plan in Management Studio? My guess is that it would be an issue in rendering the graphical execution plan. However, you can still see the plan information from the plan file (xml format).

Also, the query plan usually does not differ on the laptop and the device.

|||

I was able to identify the query bottleneck by manually interpreting the plan file, but it was an arduous task sifting through all that XML. There was a similar issue posted to the Feedback section in the SQL Server area of the Microsoft Connect website (issue id 231137) that I validated and commented on. That issue was marked closed/fixed, but there were no additional comments.

Thanks, Matthew

Here is the text of the plan file:

===================================

Error loading execution plan XML file C:\Documents and Settings\mbelk\My Documents\batitem.sqlplan. (SQLEditors)


Program Location:

at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ShowPlan.ShowPlanControl.LoadXml(String xmlFile)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ShowPlan.Editor.Microsoft.VisualStudio.Shell.Interop.IPersistFileFormat.Load(String fileName, UInt32 grfMode, Int32 readOnly)

===================================

Exception has been thrown by the target of an invocation. (mscorlib)


Program Location:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertToObjectWrapper(Object item)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.PropertyFactory.CreateProperty(PropertyDescriptor property, Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectParser.ParseProperties(Object parsedItem, PropertyDescriptorCollection targetPropertyBag, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanParser.Parse(Object item, Object parentItem, Node parentNode, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.XmlPlanNodeBuilder.Execute(Object dataSource)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ShowPlan.ShowPlanControl.LoadXml(String xmlFile)

===================================

Exception has been thrown by the target of an invocation. (mscorlib)


Program Location:

at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.PropertyFactory.CreateProperty(PropertyDescriptor property, Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectParser.ParseProperties(Object parsedItem, PropertyDescriptorCollection targetPropertyBag, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ExpandableObjectWrapper..ctor(Object item, String defaultPropertyName, String displayName)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.Convert(SeekPredicateType item)

===================================

Object reference not set to an instance of an object. (SqlMgmt)


Program Location:

at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ExpandableArrayWrapper.PopulateProperties(ICollection collection)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertToObjectWrapper(Object item)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.PropertyFactory.CreateProperty(PropertyDescriptor property, Object value)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectParser.ParseProperties(Object parsedItem, PropertyDescriptorCollection targetPropertyBag, NodeBuilderContext context)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ExpandableObjectWrapper..ctor(Object item, String defaultPropertyName, String displayName)
at Microsoft.SqlServer.Management.SqlMgmt.ShowPlan.ObjectWrapperTypeConverter.Convert(ScanRangeType item)

|||

Sorry about that. I checked out the details.

This error shows up whenever more than one column of a composite index is being used for a seek or scan.

e.g.

select * from
stores, sales where
sales.stor_id = stores.stor_id
and sales.ord_num = 'test'
- with a composite index on sales.stor_id and sales.ord_num.

For a work around, choose only one column from the index while tuning the query initially.

e.g.

select * from
stores, sales where
sales.stor_id = stores.stor_id

The plan that you get should be similar to the actual plan. For the final pass of tuning the query, use the full query!

Thanks

Pragya

sql

Tuesday, March 27, 2012

Error Installing SQL Server 2008 (July CTP)

When I install July CTP (do not have any other version of SQL on my laptop)

I am consistently getting an error

Error Code: 18456
MSI (s) (C0!4C) [01:01:33:703]: Product: Microsoft SQL Server 2008 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue Aug 28 01:01:33 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:01:33 2007
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Tue Aug 28 01:01:33 2007
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0


SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Tue Jul 24 04:09:22 2007
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148


I had the same problem when i installed MS Sql 2008.

I find the firewall deny the port (135) for SQL connecting.

After open the port of the firewall, i re-install sql successfully.

sql

Error Installing SQL Server 2008 (July CTP)

When I install July CTP (do not have any other version of SQL on my laptop)

I am consistently getting an error

Error Code: 18456
MSI (s) (C0!4C) [01:01:33:703]: Product: Microsoft SQL Server 2008 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue Aug 28 01:01:33 2007
Service MSSQLSERVER with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue Aug 28 01:01:33 2007
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Tue Aug 28 01:01:33 2007
Loaded DLL:
C:\WINDOWS\system32\Odbc32.dll
Version:
3.525.1117.0


SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=28000, level=-1, state=-1, native_error=18456, msg=[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'sa'.

Error Code: 0x80074818 (18456)
Windows Error Text: Source File Name: lib\odbc_connection.cpp
Compiler Timestamp: Tue Jul 24 04:09:22 2007
Function Name: OdbcConnection::connect@.connect
Source Line Number: 148


I had the same problem when i installed MS Sql 2008.

I find the firewall deny the port (135) for SQL connecting.

After open the port of the firewall, i re-install sql successfully.

Monday, March 26, 2012

Error Installing MSDE2000 Relase A

Hi there, This is the new installation of MSDE2000 Release A locally on the
Windows XP SP1 professional (Laptop). Never got it through the installation.
I have checked all the conditions in the Readme file, and they were met.
This is the log file:
2005-10-27 12:01:17.09 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 1)
2005-10-27 12:01:17.09 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-10-27 12:01:17.09 server All rights reserved.
2005-10-27 12:01:17.09 server Server Process ID is 2412.
2005-10-27 12:01:17.09 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG'.
2005-10-27 12:01:17.10 server SQL Server is starting at priority class
'normal'(1 CPU detected).
2005-10-27 12:01:17.12 server SQL Server configured for thread mode
processing.
2005-10-27 12:01:17.12 server Using dynamic lock allocation. [500] Lock
Blocks, [1000] Lock Owner Blocks.
2005-10-27 12:01:17.12 spid3 Warning ******************
2005-10-27 12:01:17.12 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
2005-10-27 12:01:17.13 spid3 Starting up database 'master'.
2005-10-27 12:01:17.35 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-10-27 12:01:17.35 spid5 Starting up database 'model'.
2005-10-27 12:01:17.37 server SQL server listening on 162.130.191.154:
1433.
2005-10-27 12:01:17.37 server SQL server listening on 127.0.0.1: 1433.
2005-10-27 12:01:17.37 spid3 Server name is 'HDQRKPC404445'.
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 5
2005-10-27 12:01:17.37 spid3 Skipping startup of clean database id 6
2005-10-27 12:01:17.37 spid3 Starting up database 'msdb'.
2005-10-27 12:01:17.40 server SQL server listening on TCP, Shared Memory,
Named Pipes.
2005-10-27 12:01:17.40 server SQL Server is ready for client connections
2005-10-27 12:01:17.50 spid5 Clearing tempdb database.
2005-10-27 12:01:18.12 spid5 Starting up database 'tempdb'.
2005-10-27 12:01:18.24 spid3 Recovery complete.
2005-10-27 12:01:18.24 spid3 SQL global counter collection task is
created.
2005-10-27 12:01:18.30 spid3 Warning: override, autoexec procedures
skipped.
2005-10-27 12:01:27.40 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
This is the cnfgsvr.out:
Starting Service ...
SQL_Latin1_General_CP1_CI_AS
-m -Q -T4022 -T3659
Connecting to Server ...
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
driver={sql server};server=HDQRKPC404445;UID=sa;PWD=;database= master
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified
SQL Server configuration failed.
_____________
Please advice. Thanks
hi,
TomN wrote:
> Hi there, This is the new installation of MSDE2000 Release A locally
> on the Windows XP SP1 professional (Laptop). Never got it through
> the installation. I have checked all the conditions in the Readme
> file, and they were met. This is the log file:

> [Microsoft][ODBC Driver Manager] Data source name not found and no
> default driver specified
> SQL Server configuration failed.
try fixing (or reinstalling) your MDAC stack...
http://msdn.microsoft.com/data/mdac/default.aspx
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql

Error installing MSDE (Yes, another ;) )

Hi all,
Hope someone will be able to help me out with this one.
First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l* .\log.txt"
Everything seem to works fine until there's about 5sec left.
At this point there's a MessageBox popping-up saying "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I've look at my log.txt file, and search for words like "error" or "failed" like stated by a MVP in a previous post. The only hit i've got was for "failed", like in "Setup failed to config..." the previous line might seem interesting to some : "Execut
ing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "French_CI_AS""
After i've take a look at the server logs in ...\Microsoft SQL Server\MSSQL\LOG\ and Found...
(there's a few lines before, dont think they are interesting... )
2004-05-06 16:05:01.78 spid3 Warning ******************
2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
2004-05-06 16:05:05.04 spid3 Warning ******************
2004-05-06 16:05:05.04 spid3 Attempting to change default collation to French_CI_AS.
2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
2004-05-06 16:05:05.12 server SQL Server is ready for client connections
2004-05-06 16:05:10.31 spid3 Clustered index restored for master.sysdatabases.
(here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered index restored for tempdb.xxx' )...
2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
2004-05-06 16:05:18.69 spid3 Recovery complete.
2004-05-06 16:05:18.69 spid3 SQL global counter collection task is created.
2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures skipped.
2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
Then i've look at the event System log and found an entry similar to the last line of the server log...
Event Type:Information
Event Source:Service Control Manager
Event Category:None
Event ID:7035
Date:2004-05-06
Time:16:05:23
User:xxxxxxxxxxxxxxx
Computer:xxxxxxxx
Description:
The MSSQLSERVER service was successfully sent a stop control.
I've made some searches on google and nothing come up, i've read the posts here and didnt find any answers...
I can't figure this out. Any help would be appreciated ;)
P.S. There's a folder called 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but is not working.
Thanks for your help !
Jonathan
hi Jonathan,
"Jonathan" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:A09AB00D-B6F1-4E5F-B639-7FDDC468477F@.microsoft.com...
> Hi all,
> Hope someone will be able to help me out with this one.
> First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
> I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l*
..\log.txt"
> Everything seem to works fine until there's about 5sec left.
> At this point there's a MessageBox popping-up saying "Setup failed to
configure the server. Refer to the server error logs and setup error logs
for more information."
> I've look at my log.txt file, and search for words like "error" or
"failed" like stated by a MVP in a previous post. The only hit i've got was
for "failed", like in "Setup failed to config..." the previous line
might seem interesting to some : "Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
"French_CI_AS""
>
> After i've take a look at the server logs in ...\Microsoft SQL
Server\MSSQL\LOG\ and Found...
> (there's a few lines before, dont think they are interesting... )
> 2004-05-06 16:05:01.78 spid3 Warning ******************
> 2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
> 2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
> 2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
> 2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
> 2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
> 2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
> 2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
> 2004-05-06 16:05:05.04 spid3 Warning ******************
> 2004-05-06 16:05:05.04 spid3 Attempting to change default collation to
French_CI_AS.
> 2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
> 2004-05-06 16:05:05.12 server SQL Server is ready for client
connections
> 2004-05-06 16:05:10.31 spid3 Clustered index restored for
master.sysdatabases.
> (here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered
index restored for tempdb.xxx' )...
> 2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
> 2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
> 2004-05-06 16:05:18.69 spid3 Recovery complete.
> 2004-05-06 16:05:18.69 spid3 SQL global counter collection task is
created.
> 2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures
skipped.
> 2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
>
> Then i've look at the event System log and found an entry similar to the
last line of the server log...
> Event Type: Information
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7035
> Date: 2004-05-06
> Time: 16:05:23
> User: xxxxxxxxxxxxxxx
> Computer: xxxxxxxx
> Description:
> The MSSQLSERVER service was successfully sent a stop control.
>
> I've made some searches on google and nothing come up, i've read the posts
here and didnt find any answers...
> I can't figure this out. Any help would be appreciated ;)
> P.S. There's a folder called 'C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but
is not working.
please have a look at
http://support.microsoft.com/default...99&Product=sql
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Tanks for your reply,
I didnt have any previous instance installed but i tried it anyz... But unfortunatly it didnt worked.
I dont known if this can help someone or may affect the setup, but i will post it anyz because i've seen in your link a related page stating that having sql7 tools installed may affect the setup. I know its not the same symptoms as mine, but here it is:
My laptop is setup'ed' for programming and tech.. i mean i've alot of tools to support win2000 domain and troubleshooting services such as ActiveDirectory, Sql Server, ... i also have Visual Studio .NET 2003 and debugging tools installed
My laptop is also up to date with Windows Update, and i have alot of tools installed to manage my system (Norton Anti-Virus, DiskKeeper and such (i've try disabling those services before installing, same error))
Hope someone will find something, cause i'm about to give up... Need that MSDE to be able to code while i'm travelling
Thanks for your help all !!
Jonathan

Thursday, March 22, 2012

Error in Synchronizing Data

I tried to subscribe to the database that is published on my laptop running on windows XP professional SP2 and using SQL Server 2005. However, in the second step (synchronizing data) the following error message occured:

Synchronizing Data (Error)

Messages

A request to send data to the computer running IIS has failed. For more information, see HRESULT.
HRESULT 0x80072EE2 (28037)

The operation could not be completed.

Anyone can help me on this?

Check whether you are able to browse the URL from the subscriber machine/device? It may be that IIS has blocked some extensions.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

I cannot browse the URL from the PDA. Is there any way that i can unblock those extensions?

Thanks

|||

Are you able to browse the URL from any other machine than PDA? If yes, then IIS is not blocking but its an issue of general connectivity between your PDA and desktop. Are you able to browse any site like www.microsoft.com from your PDA. If you could not browse the normal sites, then its general internet connection issue. For PDA general connectivity, please try steps from URL: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101694&SiteID=1

For IIS Help, refer to the installed IIS Documentation.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

Error in Synchronizing Data

I tried to subscribe to the database that is published on my laptop running on windows XP professional SP2 and using SQL Server 2005. However, in the second step (synchronizing data) the following error message occured:

Synchronizing Data (Error)

Messages

A request to send data to the computer running IIS has failed. For more information, see HRESULT.
HRESULT 0x80072EE2 (28037)

The operation could not be completed.

Anyone can help me on this?

Check whether you are able to browse the URL from the subscriber machine/device? It may be that IIS has blocked some extensions.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

|||

I cannot browse the URL from the PDA. Is there any way that i can unblock those extensions?

Thanks

|||

Are you able to browse the URL from any other machine than PDA? If yes, then IIS is not blocking but its an issue of general connectivity between your PDA and desktop. Are you able to browse any site like www.microsoft.com from your PDA. If you could not browse the normal sites, then its general internet connection issue. For PDA general connectivity, please try steps from URL: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=101694&SiteID=1

For IIS Help, refer to the installed IIS Documentation.

Thanks,

Laxmi NRO, MSFT, SQL Mobile, Microsoft Corporation

sql

Sunday, March 11, 2012

Error in Query

The database scheme consists of four relations:

Product(maker, model, type)
PC(code, model, speed, ram, hd, cd, price)
Laptop(code, model, speed, ram, hd, screen, price)
Printer(code, model, color, type, price)

The relation "Product" shows the maker, model number, and type (pc,
laptop, or printer). It is assumed that model numbers are unique for
all the makers and product types. For each model number specifying pc
in the relation "PC", its listed speed (of the processor in MGz), total
RAM (in MGb), hd capacity (in Gb), CD ROM speed (for example, '4x'),
and the price. The relation "Laptop" is similar to that one of PCs
except for the CD ROM speed which is replaced by screen size (in
inches). For each printer model in the relation "Printer" it is pointed
whether the printer is color or not (color attribute is 'y' for color
printers; otherwise it is 'n'), printer type (laser, jet, or matrix),
and the price.

I need to write a query for Find printer makers.
Result set: maker.

My Query is

select distinct product.maker from product inner join printer on
product.model = printer.model

I get the message
Your query produced correct result set on main database, but it failed
test on second, checking database.
* Wrong number of records (less by 1)

This question is an SQL exercise in URL http://www.sql-ex.ru/

Can anyobe explain me "correct result set on main database," why "but
it failed test on second, checking database."
* Wrong number of records (less by 1)

Thank you very much,

MiksHi Miks

> Can anyobe explain me "correct result set on main database," why "but
> it failed test on second, checking database."
> * Wrong number of records (less by 1)

My guess (emphasis on "guess") is that it has something to do with the fact
that you don't need a second table for this query. The writers of this
website, must be doing some sort of parsing of your query, this is not a
standard SQL Server error message.

This query is sufficient

select distinct maker from Product where type = 'printer'

--
-Dick Christoph
"Miks" <akmeera2k4@.gmail.com> wrote in message
news:1142418307.696828.171550@.j33g2000cwa.googlegr oups.com...
> The database scheme consists of four relations:
> Product(maker, model, type)
> PC(code, model, speed, ram, hd, cd, price)
> Laptop(code, model, speed, ram, hd, screen, price)
> Printer(code, model, color, type, price)
> The relation "Product" shows the maker, model number, and type (pc,
> laptop, or printer). It is assumed that model numbers are unique for
> all the makers and product types. For each model number specifying pc
> in the relation "PC", its listed speed (of the processor in MGz), total
> RAM (in MGb), hd capacity (in Gb), CD ROM speed (for example, '4x'),
> and the price. The relation "Laptop" is similar to that one of PCs
> except for the CD ROM speed which is replaced by screen size (in
> inches). For each printer model in the relation "Printer" it is pointed
> whether the printer is color or not (color attribute is 'y' for color
> printers; otherwise it is 'n'), printer type (laser, jet, or matrix),
> and the price.
> I need to write a query for Find printer makers.
> Result set: maker.
> My Query is
> select distinct product.maker from product inner join printer on
> product.model = printer.model
>
> I get the message
> Your query produced correct result set on main database, but it failed
> test on second, checking database.
> * Wrong number of records (less by 1)
> This question is an SQL exercise in URL http://www.sql-ex.ru/
> Can anyobe explain me "correct result set on main database," why "but
> it failed test on second, checking database."
> * Wrong number of records (less by 1)
> Thank you very much,
> Miks|||homework?|||any place where you can find the answer of these exercies?

im stuck at exercse 10:

Exercise: 10
Find the printers having the highest price.
Result set: model, price.

my query:

select model, max(price)price from printer

http://www.sql-ex.ru/exercises.php#answer_ref

any place for the answers?|||Hi Daniel

Here is one answer (One SQL Query that works)

select Model, Price
from Printer
where price = (select max(price) from Printer)

--
-Dick Christoph
"Daniel" <dtukkers@.gmail.com> wrote in message
news:1143709387.198548.201780@.z34g2000cwc.googlegr oups.com...
> any place where you can find the answer of these exercies?
> im stuck at exercse 10:
> Exercise: 10
> Find the printers having the highest price.
> Result set: model, price.
> my query:
> select model, max(price)price from printer
> http://www.sql-ex.ru/exercises.php#answer_ref
> any place for the answers?