I copied and pasted as is and I get the following...

Line 35: Incorrect syntax near 'sp_msforeachdb'.

my environment is SQL 2005 SP2.

I also get the same batch of error msgs upon parseing of the SQL.

Very strange...

I fixed ONLY first part of script "creating logins"

/****************************************

Script Made by Lester A. Policarpio

For questions...

We are using Linked Server to update AS/400 tables since a lot. We have "Jornaling" for all updateble AS/400 tables

The only problem we found is to implement DISTRIBUTED TRANSACTION between SQL Server 2000/2005...

2Yelena

Thanks a lot...

I found out ,wthat is a reason: Our Sysadmins remove from

registry keys:

REGEDIT4

[-HKEY_CLASSES_ROOT\VBScript]

@="VB Script Language"

[-HKEY_CLASSES_ROOT\VBScript\CLSID]

@="{B54F3741-5B07-11cf-A4B0-00AA004A55E8}"

[-HKEY_CLASSES_ROOT\VBScript\OLEScript]

To Enthusiast

It seems ok, and works correctly except a few small bugs, for importing collected data you need to run sqlh2.exe. Pay attention that ONLY closed log files from...

Thanks fapel

I understood that the specific component is not enable for download yet