OVH Cloud OVH Cloud

recherche grace à SQL 2000

3 réponses
Avatar
Guillaume
Bonjour,
Nous utilisons WSS2003 avec MSDE (gratuit et limit=E9 =E0 5=20
client et 2 Go de donn=E9es).
Nous n'avons pas d'outil de recherche dans WSS2003.

Nous souhaiterions savoir si en utilisant SQl SERVEUR 2000=20
il est possible d'avoir un outil de recherche des=20
documents dans WSS2003 (o=F9 peut etre que cet outil est=20
simplement dispo sous SPS?).

Que nous apporte en plus SQL SERveur2000 par rapport =E0=20
MSDE?

Merci.

Guillaume

3 réponses

Avatar
Renaud COMTE [MVP]
Bonjou

La recherche sous WSS ne fonctionne que sous SQL Server 2000 et non MSDE 2K sauf si SPS 2.0 est install
Avatar
EROL [MVP SPS]
Bonjour,



Des outils existent, mais que voulez vous faire exactement.

Voir le Blog de Renaud :
http://spsclerics.europe.webmatrixhosting.net/posts/269.aspx


Some free tools for SharePoint
Just coming back from holidays ... Too too much snow ( i need some relax now
for my knees ;) ). But i'm back, and get a ride on the internet to see
what's new on the SPS world.
And i found some great things : some new SPS little tools, sometimes with
the source code.
From James Edelen [MVP] : SharePoint Database Explorer
Very useful if you want to explore and recover documents directly from a






SQL database even if the portal go some trouble

From the Web Component Directory : GUI for STSADM.exe
A real helper for every command of STSadm.exe withou any line. You can






also save some preferences .

Jan Tielens : SharePoint Explorer Example Tool
A great sample of what we can do with .Net and Web Services







Jonathan.Malek : SPS 2.0 RSS Generator
A simple rss genrator like DevHawk syndication







D'autres outils existent plus puissant... sur SQL,
http://perso.wanadoo.fr/erolsps/SPSv2/SQL/MSDNSQL1.htm
+
http://perso.wanadoo.fr/erolsps/SPSv2/SQL/msde.htm
+
http://office.microsoft.com/search/results.aspx?Scope=TC%2CHP%2CHA%2CRC%2CFX%2CES%2CEP%2CDC%2CXT&Query=sql&CTT=6&Originì010331121036

voir le club SQL http://www.frenchsql.com/ sur le site communauté de
Microsoft.
http://www.microsoft.com/france/communautes/

et
Microsoft SQL Server 2000 Reporting Services constitue une plate-forme
serveur complète, destinée à créer, gérer et produire des rapports
traditionnels sur papier ou interactifs sur le Web. Ce produit complète les
fonctionnalités d'aide à la décision et d'entrepôt de données qui existent
dans Microsoft SQL Server et Office.

http://www.microsoft.com/france/sql/technologies/reporting/info/info.asp?mar=/france/sql/technologies/reporting/info/20031201-presentation.html
--


Allez sur le site je l'ai refait et largement développé,
voir : http://www.sharepointpro.net

@bientôt sur les news de SharePoint.
Bonne fin de semaine.

EROL
[MVP SharePoint Microsoft France]
*****************************************
http://www.sharepointpro.net
http://erolgiraudy.europe.webmatrixhosting.net/
http://perso.wanadoo.fr/erolsps/Visites/Livre1.htm
http://www.laboratoire-microsoft.org/articles/teched_2003/
============================= Si nous avons chacun un objet et que nous les échangeons, nous avons chacun
un objet.
Si nous avons chacun une idée et que nous les échangeons, nous avons chacun
deux idées.
Proverbe chinois.
===================
"Guillaume" a écrit dans le message de
news:f4c001c3f155$1412dac0$
Bonjour,
Nous utilisons WSS2003 avec MSDE (gratuit et limité à 5
client et 2 Go de données).
Nous n'avons pas d'outil de recherche dans WSS2003.

Nous souhaiterions savoir si en utilisant SQl SERVEUR 2000
il est possible d'avoir un outil de recherche des
documents dans WSS2003 (où peut etre que cet outil est
simplement dispo sous SPS?).

Que nous apporte en plus SQL SERveur2000 par rapport à
MSDE?

Merci.

Guillaume
Avatar
EROL [MVP SPS]
Bonjour,

Je viens de voir :
http://www.microsoft.com/downloads/details.aspx?familyidÎbf3c7c-7ca5-408f-88b7-f9c79b7306c0&displaylang=en
Microsoft Product Support Reporting Tool version 8.2.2003.3 for SQL Server,
last updated 7/14/03
=========================================================================== ====================
You may install and use an unlimited number of copies of MPSReports.exe
solely for the purpose of gathering system information necessary for
Microsoft Product Support Services to provide you with technical support
services requested by you. All other purposes are not supported by
Microsoft.

PURPOSE:
======= The MPS Reporting Tool is utilized to gather detailed information regarding
a systems current
configuration. The data collected will assist the Microsoft Support
Professional with fault isolation.

The reporting tool DOES NOT make any registry changes or modifications to
the operating system.
Please see the section for PACKAGE CONTENTS and DIRECTORY STRUCTURE for
details on what is copied
to the system and what directories are made. Please consult the Microsoft
Support Professional that
you are working with to determine if they want you to run MPS Reporting Tool
on all nodes in the Cluster.

USAGE:
===== This package supports Windows XP, Windows NT 4.0, Windows 2000, and Windows
2003. On execution of the package the
product type is detected to determine which commands will be utilized to
collect information.

This version supports both standard servers and Server Clusters.

Please logon to the system with the SQL server service account before
executing the tool,
failure to do so can result in having to re-execute the tool under that
context.

NOTES:
===== Average completion times for the MPS Reporting Tool are in the range of 5 to
20 minutes. Including the LDIFDE
servicePrincipleName search can extend the process running time dependent on
domain size. If for some reason
the data collection process is not completing try running the tool during
non-peak usage times.

Some common areas that prevent data collection to complete or take an
excessive amount of time:

1. A corrupted Event Log can hang DUMPEL.EXE.
2. Very large event logs can take a long time to dump. The Security log can
become very large if Auditing is enabled.
3. Many of the utilities require that RPC (Remote Procedure Call) be
operating at some capacity.
4. Disk/Controller problems can prevent inventory of various files hanging
or slowing down the process.
5. If Quick Edit is enabled, if you select any text in the "Command" Windows
it will effectively pause the MPS
Reports. Press the "ESC" key to exit out and let the MPS Reports continue

Utilize the %ComputerName%_PROGRESS.TXT file to determine which process is
not completing. Correcting any
issue that prevents the MPS Reports from completing in some cases resolves
the issue that prompted the need
for the utility to be run.

It is required that the currently logged on user have Administrative rights
in order to allow for proper
operations of the MPS Reporting Tool.

If you have any questions regarding the usage or operations of the MPS
Reporting Tool consult with the
Microsoft Support Professional you are working with.

PACKAGE CONTENTS:
================ 2000.cmd - Contains all commands to run if machine is running Windows
2000.
adsutil.vbs - IIS administrative script normally found in the
%drive%:InetpubAdminScripts folder.
CHECKSYM.EXE Version 2.3.0.0 - Utility that gathers version and symbol
information from executable files
Checksym.txt - Readme file for CHECKSYM.EXE.
Checksym_EULA.RTF - EULA for Checksym.exe.
CHOICE.EXE - Resource Kit utility.
CLUSMPS.EXE - Utility to capture Cluster specific information.
DBGHELP.DLL Version 5.0.2195.2104 - Support file for CHECKSYM.EXE
Devcon.exe Version 5.1.3574.0 - Utility that dumps all the Devices and
connections.
Diskinfo.exe - Disk Information Utility.
DISKMAP.EXE - Disk Information Utility.
DMDiag.exe Version 5.1.2600.1164 - Disk Information Utility.
DOSDEV.EXE Version 5.2.3772.0 - Utility to capture Drive Letter to Device
mapping.
Drvman.exe Version 3.0.0.2 - Utility that gathers Printer Driver
information.
DUMPEL.EXE - Utility to dump the event logs in TXT format.
DumpEVT.exe - Utility to dump the event logs in EVT format.
EULA.TXT - End-User License Agreement for this tool.
Finish.cmd - Contains all commands necessary to build the cab file.
FltrFind.exe - Utility that gathers information about upper and lower
filters installed on a machine.
FTDMPNT.EXE - Utility that dumps out Disk Information such as disk
signature.
GETVER.EXE - Utility used to determine version of Windows NT running.
GPRESULT.EXE Version 5.2.3765.0 - Resource Kit utility to dump the Group
Policies on this box.
Htdump.exe - Utility that detects whether a processor is HyperThreading
capable.
Kerbcheck.cmd - Genereates Kerberos specific information.
LDIFDE.EXE Version 5.0.2195.4866 - Domain Controller Directory Exchange
tool.
LDIFDE_Decoding.txt - Expalins how to decode ldifde reports to discover
server delegation.
MAKECAB.EXE Version 5.2.3765.0 - Utility to package reports.
MPSRpt.cmd - Command script used to create all the reports.
MSDBI60.DLL Version 6.0.8104.0 - Support file for CHECKSYM.EXE.
MSVCRT.DLL Version 6.1.8924.0 - Support file for CHECKSYM.EXE.
Net.cmd - Contains all commands to run if machine is running
Widnows Server 2003.
NetDiag.exe Version 5.2.3675.0 - Network diagnostics utility
Netxp.exe Version 5.1.2600.0 - Network Diagnostics for Windows XP, 2003
NT4.cmd - Contains all commands to run if machine is running
Windows NT 4.
OEMINBOX.EXE - Resource Kit utility to dump all of the printer
information.
PnpEnum.exe Version 5.0.2134.1 - Utility that gathers information in the
Enum key in the registry.
PSAPI.DLL Version 5.0.2134.1 - Support file for CHECKSYM.EXE.
PSTAT40.EXE Version 4.0.1371.1 - Resource Kit utility to dump running
processes and device drivers 4.0.
PSTAT50.EXE Version 5.2.3772.0 - Resource Kit utility to dump running
processes and device drivers 2000.
PSTAT.EXE Version 5.1.2600.0 - Resource Kit utility to dump running
processes and device drivers XP.
README.TXT - This file.
REG.EXE Version 2.0.0.0 - Resource Kit utility to dump registry
values.
SaveLogBottom.exe - Utility that saves the bottom few logs in a Dr. Watson
log.
SQL.cmd - Generates SQL Specific Reports.
SQL.TXT - Additional information on what to do with this
information plus additional requests.
Tapedrive.vbs - Utility that will tell us all about the Tape Drive on the
machine.
Tlist.exe Version 6.0.4019.0 - Utility that lists current processes and sub
processes.
UnsgnDrv.exe - Utility that gathers signed and unsigned drivers on the
machine.
W2K_Dcdiag.exe - Dcdiag.exe renamed for OS version, performs Domain
Controller Diagnostics
W2K_Netdiag.exe - Netdiag.exe renamed for OS version, performs Network
Diagnostics
W2K3_Dcdiag.exe Version 5.2.3790.0 - Dcdiag.exe renamed for OS version,
performs Domain Controller Diagnostics
W2K3_Netdiag.exeVersion 5.2.3790.0 - Netdiag.exe renamed for OS version,
performs Network Diagnostics
W2K3_GPRESULT.EXE Version 5.2.3790.0 - Resource Kit utility to dump the
Group Policies on this box.
XP.cmd - Contains all commands to run if machine is running Windows
XP.


DIRECTORY STRUCTURE:
=================== %SystemRoot%MPSReports---|
|-- SQLServer --|
|-- Bin
|-- Report --|
|-- Cab
|-- SQLSpecific


ADDITIONAL INFORMATION:
====================== Two .CAB files will be generated for your convenience in the
%systemroot%MPSReportsClusterReportCab directory called
%ComputerName%_MPSReports.CAB an %ComputerName%_SQL.CAB. The CAB file will
contain the reports generated by
the MPS Reporting Tool. Please send the cab file to the Microsoft Support
Professional
who is working on your support incident.

WHAT IS COLLECTED on my system?
============================== The scripts create a variety of reports in the
%SYSTEMROOT%MPSReportsReport and ReportSQLSpecifc directories.

%ComputerName%_BOOT_INI.TXT Copy of the BOOT.INI for the system
%ComputerName%_CLUSTER.LOG Copy of the Cluster Log
%ComputerName%_CLUSTER.OML.TXT Copy of the Cluster.OML file from the
Cluster Folder. Windows 2003 only
%ComputerName%_CLUSTER_BAK.LOG Copy of the Cluster.Log.Bak if created
%ComputerName%_CLUSTER_CHKDSK.LOG Copy of the ChkDsk.Log files from the
Cluster Folder
%ComputerName%_CLUSTER_CLCFGSRV Copy of the Cluster Configuration Log.
Windows 2003 only
%ComputerName%_CLUSTER_DIR.CSV List the contents of the Cluster Folder to
capture version information
%ComputerName%_CLUSTER_DIR.TXT List the contents of the Cluster Folder to
capture version information
%ComputerName%_CLUSTER_MPS_INFORMATION.TXT Information on the cluster such
resource types, priority,and dependencies
%ComputerName%_CLUSTER_PROPERTIES.TXT List of Private Properties of
Resources
%ComputerName%_CLUSTER_REGISTRY.HIV Copy of the Cluster Registry
%ComputerName%_CLUSTER_RESOURCES.TXT List of Cluster Resources and state
%ComputerName%_Comsetup.log Copy of Com+ Setup log file.
%ComputerName%_CurrentControlSet.HIV Copy of the CurrentControlSet registry
hive.
%ComputerName%_CURRENTVERSION_MDAC_REG.TXT Current MDAC registration.
%ComputerName%_DBerr.txt (removed) Copy of the SP Catalog logging file.
%ComputerName%_DCDIAG.TXT Domain Controiller Diagnostics Information
%ComputerName%_DEFAULT_INST_SQLDIAG.txt SQL Server 2000 Diagnostics tool
results for a default instance.
%ComputerName%_DEVCON.TXT PNP Information for all Devices in the machine.
%ComputerName%_DISK_INFORMATION.TXT (removed) Drive Letter to physical disk
mapping
%ComputerName%_DISK_INFORMATION.TXT (removed) Saves out information on Disk
in the System.
%ComputerName%_Diskinfo.txt (removed) Low level look at MBR, PBS, and MFT.
%ComputerName%_Diskmap.txt (removed) Low level look at MBR, and PBS.
%ComputerName%_DMDiag.log (removed) Dynamic Disk Log.
%ComputerName%_DNS.log DNS Debug logs
%ComputerName%_DOSDevices.txt Hardware PCI Information.
%ComputerName%_DriverQuery.txt Tells If the installed Drivers are signed
or not.
%ComputerName%_Drivers.csv Comma Seperated file of a checksym of the
drivers.
%ComputerName%_DRIVERS.TXT [.CSV] Output of the
%SystemRoot%System32Drivers directory.
%ComputerName%_Drvman.txt Output of Drvman.exe for printer driver
information installed.
%ComputerName%_DrWatson.log Bottom few logs from the Dr. Watson log
file.
%ComputerName%_DrWtsn32.log Bottom few logs from the Dr. Watson 32 Log
File. On Server 2003 this has the Username in the file name.
%ComputerName%_EVENT_LOG_application.txt [.EVT] Output of the Application
Event Log.
%ComputerName%_EVENT_LOG_security.txt [.EVT] Output of the Security Event
Log.
%ComputerName%_EVENT_LOG_system.txt [.EVT] Output of the System Event Log.
%ComputerName%_Filters.txt List of the Upper and Lower filters
installed.
%ComputerName%_FTDMPNT.txt (removed) Diskprobe look of MBR and PBS of
each drive.
%ComputerName%_GPResult.txt Log from a run of the GP result command to
tell which policies were applied to the machine.
%ComputerName%_HCUpdate.log Hardware Compatibility Update Log.
%ComputerName%_HOTFIX.TXT A simple directory listing of directory names
for installed hotfixes
%ComputerName%_HOTFIXREG.TXT Listing of the HOTFIX Key from the registry
%ComputerName%_HyperThread.txt File that Tells If the processors in the
machine are HyperThreading capable.
%ComputerName%_IIS*.log IIS log file for whichever version is installed
on the machine.
%ComputerName%_Internet_Settings_Key.txt Registry entries for the Internet
Settings information provided through IE.
%ComputerName%_LDIFDE.TXT LDIFDE Active Directory reporting of SPN name,
SAMAccountName and servicePrincipleName (last variable only reported if a
domain administrator is the login executing the tool)
%ComputerName%_MDAC_ADO_DLL.TXT [.CSV} MDAC ADO DLL listing
%ComputerName%_MDAC_CurrentControlSet.TXT MDAC text listing of
CurrentControlSet
%ComputerName%_MDAC_DASETUP.TXT MDAC dasetup log
%ComputerName%_MDAC_DAHOTFIX.TXT MDAC hotfix listing
%ComputerName%_MDAC_ExceptionComponents.TXT MDAC listing of the MDAC
exception components
%ComputerName%_MDAC_MSADC_DLL.TXT [.CSV} MDAC DLL listing
%ComputerName%_MDAC_OLEDB_DLL.TXT [.CSV] MDAC OLEDB DLL listing
%ComputerName%_MDAC_GAC_SYSTEM_DATA.TXT MDAC GAC system data
%ComputerName%_MDAC_GAC_SYSTEM_XML.TXT MDAC GAC system XML data
%ComputerName%_Microsoft.HIV Copy of the current Microsoft registry hive
%ComputerName%_MISC.txt Copy of Environment variables, shares, and other
MISC information
%ComputerName%_MountedDevices.txt (removed) Copy of the Mounted Devices
Key from the registry.
%ComputerName%_MSINFO.nfo Windows 2000 and Windows 2003
%ComputerName%_ORACLE_MDAC_REG.TXT Oracle MDAC registration
%ComputerName%_Net.txt Networking information file.
%ComputerName%_NETDIAG.TXT NEtwork Diagnostics
%ComputerName%_NetSetup.log Log of events when joining a domain.
%ComputerName%_NI.txt Output of various components for Network related
information
%ComputerName%_NLB_INFORMATION.txt Output from WLBS /display
%ComputerName%_NTAuthenticationProviders.TXT Listing of the IIS server NT
Authentication methods
%ComputerName%_NtBtLog.txt If boot logging enabled this is the log file
for it.
%ComputerName%_Ocgen.log (removed)
%ComputerName%_OLEDB_DLL.TXT [.CSV] Output of the program filescommon
filessystemole db for all .dll files.
%ComputerName%_PNPEnum.txt(removed) file that lists all the PNP Devices
and their GUIDS.
%ComputerName%_Print.txt (removed) Registry of Print Keys.
%ComputerName%_PrintDrivers.txt(removed) List of all printer Drivers
installed and versions.
%ComputerName%_Printkey.txt(removed) Registry of Print Keys.
%ComputerName%_PROCESS.TXT [.CSV] Output of the currently running processes
on the system.
%ComputerName%_PROGRESS.TXT MPS Reporting Progress log.
%ComputerName%_PSTAT.TXT Output of a list of processes and active device
drivers.
%ComputerName%_QPROCESS.TXT Output for Terminal Server processes. Windows
2000/.NET only.
%ComputerName%_QUSER.TXT Output for Terminal Server current users. Windows
2000/.NET only.
%ComputerName%_QWINSTA.TXT Output for Terminal Server Win Station
Information. Windows 2000/.NET only.
%ComputerName%_RECOVERY.TXT (removed)
HKLMSystemCurrentControlSetControlCrashControl(see
%ComputerName%_CurrentControlSet.HIV)
%ComputerName%_Running_Services.txt List of currently running services
%ComputerName%_Schdlgu.txt Task Scheduler tasks.
%ComputerName%_SCHED.csv Output from the scheduler command AT.EXE
%ComputerName%_SCHEDLGU.TXT Scheduled Task Log Windows 2000 and Windows
2003
%ComputerName%_SESSIONMANAGER.HIV (removed)
HKLMSystemCurrentControlSetControlSession Manager (see
%ComputerName%_CurrentControlSet.HIV)
%ComputerName%_Setup.log Current SQL Server Setup.log on the machine in
the config directory.
%ComputerName%_SetupAct.log (removed) Setup Activity Log.
%ComputerName%_SetupApi.log Setup log file.
%ComputerName%_SetupErr.log Setup Error log file.
%ComputerName%_SetupLog.txt (removed) Setup log file.
%ComputerName%_Spool.txt (removed) Text file of printer Drivers
installed.
%ComputerName%_SQLCLSTR.TXT SQL Server cluster setup log.
%ComputerName%_SQL_COM_BINN.TXT [.CSV] File listing and versioning of the
common SQL Server directory
%ComputerName%_SQL_DEFAULT_BINN.TXT [.CSV] Output of the C:Program
FilesMicrosoft SQL ServerMSSQLBinn directory version and symbol
information from executable files
%ComputerName%_SQL_Servers.txt Registry reported InstalledInstances
%ComputerName%_SQLSP.TXT [SP#.TXT] SQL Server service pack setup log, up to
the last 5 logs included.
%ComputerName%_SQLSTP.TXT [STP#.TXT SQL Server setup log, up to the last 10
logs included.
%ComputerName%_SYSTEM32_DLL.TXT [.CSV] Output of the Windows NT System32
directory for all .DLL files.
%ComputerName%_SYSTEM32_EXE.TXT [.CSV] Output of the Windows NT System32
directory for all .EXE files.
%ComputerName%_TapeDrive.txt Output of TapeDrive.vbs with Tape Drive
Information.
%ComputerName%_Tlist.txt List of all current Processes and Sub Processes.
%ComputerName%_Tsoc.log TS log file.
%ComputerName%_Uninstall.txt (removed) Registry information for installed
applications.
%ComputerName%_Upgrade.txt (removed) Log of upgrade progress.
%ComputerName%_Vminst.log Log from Virtual machine installation.
%ComputerName%_Wiadebug.log (removed) Windows Imaging Log.
%ComputerName%_Wiaservc.log (removed) Windows Imaging Service Log.
%ComputerName%_WindowsUpdate.log Log file created by Windows Update
Service.
%ComputerName%_Winmsd.nfo NFO format of Winmsd.
%ComputerName%_winmsd.TXT Windows NT 4.0
%ComputerName%_Winnt32.log Log of events when Winnt32 was run.
%ComputerName%_Wsdu.log Windows Update log file.
%UserName%_%ComputerName%_LDIFDE.TXT LDIFDE report for current user
DOMAINWIDE_LDIFDE_for_%USERDOMAIN%.TXT LDIFDE report for entire domain

HISTORY:
=======
Version Changes
------- ---------------------------------------------------------------
8.2.2003.3 - Edited readme file
8.2.2003.2 - Removed QFECHECK.EXE do to incompatibility with Windows XP
and Windows 2003
8.2.2003.1 - Removed PNPEnumeration and replaced with Devcon reporting,
- Added Windows 20003 GPresult tool,
- Added file versioning,
- Updated versioning numbering to be consistant with MPS reports
standards.
8.2 - Re-enabled Netdiag, Netstat and PNPEnumeration reporting
8.1 - Fixed error causing event log gathering to fail, removed several
reports (25) as noted above,
removed extra registry hive reports which is already gathered
in the Microsoft and
CurrentControlSet hives, added timer to Kerberos report menu
defaulting to not run
reports after 5 seconds. Added Netdiag and DCDiag reporting
Updated file versioning properties on installation executable.
8.0 - Added Kerberos/SSPI information gathering, File version and
symbol information for default instance,
version and symbol information for QL Server 8.0 COM folder, SQLDIAG
for default instance and support
for the following operating systems, NT4, Windows XP, Windows 2000,
Windows 2003.
Directory structure changed to provide SQL folder instead of using
cluster folder as was previously done.
7.0 - No longer have FULL/LITE versions, only run a single version.
GETTYPE.EXE is no
longer used detect version information, simply look at a VER
output. Added CLUSMPS
to gather Cluster information. Added DOSDEV to capture
additional Disk information.
Capture CHKDSK logs that Cluster Service generates in a more
readable manner. Removed
unneeded and duplicate information. Contains all information
gathered by MDAC MPS
Reporting Tool
6.0f - Enhanced MDAC gathering capability with addition of Oracle
information gathering
6.0e - Added MDAC gathering capability
6.0d - Changed tools behavior so that only previously generated MPS
Reports are deleted on re-execution of the tool
- Modified where to start copying the SQL query and requested SAN
configuration information
6.0c - Added HKLMSoftwareODBC as requested.
6.0b - Modified cmd files so that only the 0-MPSRpt.cmd and 5-
commands have to be updated
if the base is updated.
- Changed name to reflect new year and version
- Added SAN configuration confirmation request to COMPLETE.TXT
6.0a - Added date sorted %systemroot% *.log listing in the SQL cab
file
- Increased number of sqlsp logs collected from 0-5 to 0-9
- Added request for Compaq Survey level 3 reports to the
complete.txt
6.0 - Modified event log formatting
- Brought version in line with MPSRPTS_2001_CLUSTER.EXE
- Modified SQL query to place SP_CONFIGURE at the top of the
report
3.0 - Revised based on the MPSRPTS_2001_CLUSTER.EXE version 6.0.
Detects previous copy of MPS Reports and prompts to delete,
also removes previous SQL reporting structure.
Integrated version numbering into executable for easy version
distinction.
Separate CAB files for Cluster (
%ComputerName%_MPSReports_Cluster.CAB ) and
SQL ( %ComputerName%_SQL.CAB ) to keep size and purpose isolated.
Returned to the original directory structure, SQL Server specific
information now gathered
in SQL Folder under %SystemRoot%MPSReportsCluster.
netstat now ran per OS and includes -o parameter for .Net servers to
return PID information.
%ComputerName%-MISC.txt now includes listing of localgroup
administrators.
2.0b - Modified Network gathering to include both "netstat -a" and
"netstat -an"Version Changes.
2.0a - Added SQL Service Pack log gathering.
2.0 - Changed location from %SystemRoot%MPSReportsCluster to
%SystemRoot%MPSReportsSQL
Renamed from MPSRPTS_2000_SQL_CLUSTER.EXE to
MPSRPTS_2000_SQL.EXE.
1.0 - Initial version, based on version 5.0 of the Cluster MPS
reporting tool.

--



Allez sur le site je l'ai refait et largement développé,
voir : http://www.sharepointpro.net

@bientôt sur les news de SharePoint.
Bonne fin de semaine.

EROL
[MVP SharePoint Microsoft France]
*****************************************
http://www.sharepointpro.net
http://erolgiraudy.europe.webmatrixhosting.net/
http://perso.wanadoo.fr/erolsps/Visites/Livre1.htm
http://www.laboratoire-microsoft.org/articles/teched_2003/
============================= Si nous avons chacun un objet et que nous les échangeons, nous avons chacun
un objet.
Si nous avons chacun une idée et que nous les échangeons, nous avons chacun
deux idées.
Proverbe chinois.
===================
"Guillaume" a écrit dans le message de
news:f4c001c3f155$1412dac0$
Bonjour,
Nous utilisons WSS2003 avec MSDE (gratuit et limité à 5
client et 2 Go de données).
Nous n'avons pas d'outil de recherche dans WSS2003.

Nous souhaiterions savoir si en utilisant SQl SERVEUR 2000
il est possible d'avoir un outil de recherche des
documents dans WSS2003 (où peut etre que cet outil est
simplement dispo sous SPS?).

Que nous apporte en plus SQL SERveur2000 par rapport à
MSDE?

Merci.

Guillaume