Migrating form Oracle 8 to SQL2000

Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...I heard of both the products, but I have seen DBBest in action at PASS 2003,
in Seattle, WA. Though I haven't tried it myself, it seems like a very good
product.
This might help:
http://vyaskn.tripod.com/ oracle_sq...ent
s.htm
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"unwar" <anonymous@.discussions.microsoft.com> wrote in message
news:uclsp0xCEHA.1600@.tk2msftngp13.phx.gbl...
Has there anyone heard these two 3rd-party tool "SwisSQL" and "DbBest",
which say can full converting Oracle to SQL Server, includes Triggers and
Views?
I got this on KB already
http://www.microsoft.com/resources/...r />
0761.mspx
but I still hope if there're some other choice and much more convenient...

Migrating data from DB2 to SQL Server

Hello,

I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.

Sincerely,

Eldhose Cyriaccontact1981 wrote:

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.

Yes, of course.
To you push data regularly or is this a once of.
If you have to do it often you could consider Websphere Information
Integegrator. It allows you to push/pull data through normal SQL from
and to DB2.

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

IOD Conference
http://www.ibm.com/software/data/on...iness/conf2006/|||Hi

There is migration information at
http://www.microsoft.com/sql/prodin...bm/default.mspx, migration
tools exist for Oracle, Access and Sybase but there does not seem to be a
released version for DB2
http://www.microsoft.com/sql/soluti...on/default.mspx I suggest you
contact the SQL Server Migration team at the email address under the related
links on that page.

John

"contact1981" <contact1981@.gmail.comwrote in message
news:1154637593.696660.274720@.p79g2000cwp.googlegr oups.com...

Quote:

Originally Posted by

Hello,
>
I am trying to migrate data from a DB2 database to SQL Server 2005
database. Does anyone know about any migration tool that does that? I
have heard about DB2 Migration Tool kit, but I think you can only
migrate data to a DB2 database with that. Thank you.
>
>
Sincerely,
>
Eldhose Cyriac
>

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?
Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?
sql

Migrate to New Domain

I migrated my SQL 7 server running on Win 2K Server from
the existing domain to a new domain using the Active
Directory Migration tool but now SQL won't start and I
cannot get it to start whether I log on to the old or new
domains. Does anyone have an insight?Wht error do yo get? I guess SQL Server service can't logo to Windows
domain. Check te username and password SQL Server service is using.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:54af01c42cdd$7a56a5f0$a101280a@.phx.gbl...
> I migrated my SQL 7 server running on Win 2K Server from
> the existing domain to a new domain using the Active
> Directory Migration tool but now SQL won't start and I
> cannot get it to start whether I log on to the old or new
> domains. Does anyone have an insight?

Migrate SSRS 2005 Reports

Hi,

I need to move few folders from our DEV SSRS 2005 environment to another
server. Folders will be moved to new parent folders.
Is there any tool that I can use fot this purpose?
I used RSScripter from SQLdbatips.com. Although the tool works great but it
can't script multiple folder reports. I have to script one by one and it is
a big problem.

Thanks
AlexIt cannot? I have version 2.0.0.6 and I can select multiple folders.

Migrate from Crystal Reports to SQL Server Reports

I have a requirement to convert reports from Crystal Reports to SQL
Server Reports. Is there any tool to do this? or Do I need to redesign
every report in SQL Server Reports?
MadhivananI have the same problem and spent a few days looking for converters and
other help. Unfortunately, there aren't any. The Crystal format is
proprietary, and I didn't find a converter.
--
Floyd
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1125989239.108925.278830@.g43g2000cwa.googlegroups.com...
>I have a requirement to convert reports from Crystal Reports to SQL
> Server Reports. Is there any tool to do this? or Do I need to redesign
> every report in SQL Server Reports?
> Madhivanan
>|||From Crystal [Licence.pdf]
4.6.5 (Excerpt)
"End User agrees not to alter, disassemnble, decompile, translate, adapt or
reverse-engineer the Runtime Software or the report file (.RPT) format"
"End user agrees not to use the runtime software to create for distribution
a product that converts the report file (.RPT) format to an alternative
report file format ... or product that is not the property of Crystal
Decisions"
"Floyd Burger" wrote:
> I have the same problem and spent a few days looking for converters and
> other help. Unfortunately, there aren't any. The Crystal format is
> proprietary, and I didn't find a converter.
> --
> Floyd
> "Madhivanan" <madhivanan2001@.gmail.com> wrote in message
> news:1125989239.108925.278830@.g43g2000cwa.googlegroups.com...
> >I have a requirement to convert reports from Crystal Reports to SQL
> > Server Reports. Is there any tool to do this? or Do I need to redesign
> > every report in SQL Server Reports?
> >
> > Madhivanan
> >
>
>|||Thanks. It seems that redesign is the only way
Madhivanan

Migrate from Access to SQL 2005

Dear friends,

I'm trying to migrate my database in MS Access to SQL 2005. With the tables I dont have any problem using the Microsft tool for that. But I dont know how can I migrate StoredProdures/Views created in Access...

I have about 300 SP and views in database access.

thanks

Someone help me?|||stored procedure in sql server is completely different from access. you may have to recode your sp's

Migrate from 2000 to 2005

Is there a tool available (or planned) to migrate SQL Server 2000 database to SQL Server 2005 ? I came across this (http://www.timespring.net/TS_TD_SQL05offer.htm?track=NL-464&ad=524331) but are there any other tools ?
Has Microsoft planned anything of its own for this ?http://www.microsoft.com/downloads/details.aspx?familyid=63FCE120-5E87-4AF1-B080-CA461AEAFAA2&displaylang=en

Looking for something like this ?? Moreover, SQL Server 2005 will contain a upgrade wizard AFAIK.|||Thanks for the response. Yes, I went through (and even tried) SQL Server Ugrade advisor. But not sure if Microsoft has plans to ship "Upgrade Wizard" kind of utility as shipped with SQL Server 2000. I couldn't find any reference to such utility being planned in their site.|||Quoting from the new version of the HOLY BOOK (BOL 2005)

Upgrading to SQL Server 2005 from a previous SQL Server version is supported by the SQL Server 2005 Setup program. You can also migrate databases from previous SQL Server versions to an instance of SQL Server 2005. Migration can be from one SQL Server instance to another on the same computer, or from a SQL Server instance on another server. Migration options include use of the Copy Database Wizard, Backup and restore functionality, use of the SQL Server 2005 Integration Services Import and Export Wizard, and bulk export/bulk import methods.|||More information on how to upgrade : http://msdn2.microsoft.com/en-us/library/default.aspx.

Web Version of the new BOL can be found here.

Microsofts Sql web admin and sqldmo

Hello all,

has anyone had the opportunity to try the sql web admin tool? if so, i have one question.

How can i use this to connect to a remote sql/msde server?

in the server textbox on the login screen i try 'machine name'\'instance name', along with the sa username and password. This does not work however.

am i just entering the wrong value , or do i need to change the code of the .connect method to allow for remote connections?

TIA.

-C-By "does not work", do you mean you are getting an error?

I have been successful using Web Data Administrator to connect to a remote database. The remote database must have mixed authentication (SQL Server and Windows). and you must be using a valid login and password. I accessed the server using the IP address.

As an additional point, I was VPN authenticated on the remote network before connecting.

Terri

Microsoft! What about full Bidi (RightToLeft) support??

Such a wonderful & powerful tool but no support for true RightToLeft in the
designer and in the browser page level!
Microsoft! Please consider this for SQL Server 2005.
Thanks in advanced :)
AsafAsaf - can you provide examples of where this does not work for you? (if
you could mark them up with desired behaviors, since we may not be able to
read it :-)).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Asaf" <asafgo@.hotmail.com> wrote in message
news:eh9hykMAFHA.1392@.tk2msftngp13.phx.gbl...
> Such a wonderful & powerful tool but no support for true RightToLeft in
> the designer and in the browser page level!
>
> Microsoft! Please consider this for SQL Server 2005.
>
> Thanks in advanced :)
> Asaf
>

Microsoft SQL Server Health and History Tool

Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?
Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
================================================== ====
Get Secure! - www.microsoft.com/security
================================================== ====
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties,and confers no rights.
================================================== ====
--[vbcol=seagreen]
and[vbcol=seagreen]

Microsoft SQL Server Health and History Tool

Hi All
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
Thanks
Yes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:

> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Ca ption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZon e,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles, FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime ,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUse rs,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVe rsion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,Syst emDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisib leMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>

Microsoft SQL Server Health and History Tool

Hi All
I am reciving the following error when running the
Microsoft SQL Server Health and History Tool:
22/09/2004 1:48:56 PM INFO: version: 8.00.760
22/09/2004 1:48:56 PM Status: RUN
22/09/2004 1:48:56 PM Status: Initializing
collector: WMI
22/09/2004 1:48:56 PM Status: Running WMI collector
22/09/2004 1:48:56 PM Status: Opening Unit 1
(OS/CS)
22/09/2004 1:48:56 PM Status: Collecting
Win32_OperatingSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_ComputerSystem
22/09/2004 1:48:56 PM Status: Collecting
Win32_Processor
22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
syntax near 'c09'.
22/09/2004 1:48:58 PM Status: Closing Unit 1
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM WARNING: WMI Collector
encountered critical error. Abandoning Collector.
22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
(run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
Size,Version,WindowsDirectory) Values (3,
1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
Free', 'Microsoft Windows XP
Professional', '1252', '61', 'Service Pack 1', 'test01',
600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
3112032, 522220, '5.1.2600', 'C:\WINDOWS')
22/09/2004 1:48:58 PM ERROR: test01: Collection
failed; Error:104; Provider Error: 170
22/09/2004 1:48:58 PM ERROR: Critical Repository
Failure
22/09/2004 1:48:58 PM SQLH2 is shutting down
22/09/2004 1:48:58 PM Closing Log
Has anyone come acrosss this error and can advise.
ThanksYes, i also have problems too.
And i think there is a problem with our collation settings. (Which is
Turkish_CI_AS).
Also reports are not working because of that i think. Hate this localization
problems.
I will try on English Locale server and see if it works..
"anonymous@.discussions.microsoft.com" wrote:
> Hi All
> I am reciving the following error when running the
> Microsoft SQL Server Health and History Tool:
> 22/09/2004 1:48:56 PM INFO: version: 8.00.760
> 22/09/2004 1:48:56 PM Status: RUN
> 22/09/2004 1:48:56 PM Status: Initializing
> collector: WMI
> 22/09/2004 1:48:56 PM Status: Running WMI collector
> 22/09/2004 1:48:56 PM Status: Opening Unit 1
> (OS/CS)
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_OperatingSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_ComputerSystem
> 22/09/2004 1:48:56 PM Status: Collecting
> Win32_Processor
> 22/09/2004 1:48:58 PM ERROR: Line 1: Incorrect
> syntax near 'c09'.
> 22/09/2004 1:48:58 PM Status: Closing Unit 1
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM WARNING: WMI Collector
> encountered critical error. Abandoning Collector.
> 22/09/2004 1:48:58 PM ERROR: Insert dbo.c_wmi_OS
> (run_id,srv_id,BootDevice,BuildNumber,BuildType,Caption,Co
> deSet,CountryCode,CSDVersion,CSName,CurrentTimeZone,Debug,
> Distrib,FreePhysicalMemory,FreeSpaceInPagingFiles,FreeVirt
> ualMemory,InstallDate,LastBootUpTime,LocalDateTime,Locale,
> MaxProcessMemorySize,NumberOfProcesses,NumberOfUsers,OSLan
> guage,OSProductSuite,PAEEnabled,ServicePackMajorVersion,Se
> rvicePackMinorVersion,SizeStoredInPagingFiles,SystemDevice
> ,SystemDirectory,TotalVirtualMemorySize,TotalVisibleMemory
> Size,Version,WindowsDirectory) Values (3,
> 1, '\Device\HarddiskVolume2', '2600', 'Multiprocessor
> Free', 'Microsoft Windows XP
> Professional', '1252', '61', 'Service Pack 1', 'test01',
> 600, 0, 0, 102104, 2102060, 2204164, '01/09/2004
> 08:35:38', '09/21/2004 04:34:18', '09/22/2004 13:48:56',
> 0c09, 2097024, 55, 5, 1033, -1, 0, 1, 0,
> 2589812, '\Device\HarddiskVolume2', 'C:\WINDOWS\System32',
> 3112032, 522220, '5.1.2600', 'C:\WINDOWS')
> 22/09/2004 1:48:58 PM ERROR: test01: Collection
> failed; Error:104; Provider Error: 170
> 22/09/2004 1:48:58 PM ERROR: Critical Repository
> Failure
> 22/09/2004 1:48:58 PM SQLH2 is shutting down
> 22/09/2004 1:48:58 PM Closing Log
>
> Has anyone come acrosss this error and can advise.
> Thanks
>

Microsoft SQL Server Health and History Tool

Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads/details.aspx?FamilyID=eedd10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Reply-To: "TM" <tmcclenn@.community.nospam>
>>From: "TM" <tmcclenn@.community.nospam>
>>Subject: Microsoft SQL Server Health and History Tool
>>Date: Mon, 6 Nov 2006 10:45:23 -0500
>>Lines: 5
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <#B$rSqbAHHA.1224@.TK2MSFTNGP04.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: ip70-161-7-200.hr.hr.cox.net 70.161.7.200
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP04.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:450417
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Anyone have any experience or comments using Microsoft SQL Server Health
and
>>History Tool?
>>
>>

Microsoft SQL Server Health and History Tool

Anyone have any experience or comments using Microsoft SQL Server Health and
History Tool?Hi,
The Microsoft SQL Server Health and History Tool (SQLH2) allows you to
collect information from instances of SQL Server, store this information,
and run reports against the data in order to determine how SQL Server is
being used.
http://www.microsoft..com/downloads...d10d6-75f7-4763
-86de-d2347b8b5f89&DisplayLang=en
Run the SQLH2 collector to help us collect feature usage information on SQL
2005(and SQL 2000) deployments. Then when the reports come out you (and
your customers) can easily view the collections.
Please understand, this question appears to be consulting in nature.
Although this newsgroup is here to provide break/fix resolution, we are
happy to provide general information and suggestions on it here and you may
receive suggestions from other partners on this topic both here and in the
public newsgroup for this product.
If you need further information, we would also like to introduce you to the
CUSTOMER SERVICE AND SUPPORT (CSS) Advisory Services team.
Advisory Services is a remotely delivered, hourly fee-based, consultative
support option that provides a comprehensive result beyond your break-fix
product maintenance needs. It is an hourly fee-based, consultative
support option that provides proactive support beyond your break-fix
product maintenance needs. This support option includes working with the
same technician for assistance with issues like product migration, code
review, or new program development.
For more info in the US and Canada:
http://support.microsoft.com/gp/advisoryservice
Outside of the US/Canada:
http://support.microsoft.com/common/international.aspx
Thanks for understanding.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
and[vbcol=seagreen]