Hi,

Small question, we are installing SQL Server 2000 on our laptops using a VBScript. Before we apply SP4, we want to make sure that the SQL standard edition has been installed properly and not parts of it. This has not always been the case because of network issues etc. Currently we do a check if the sqlservr.exe exists on the laptop, but that is just plain useless.

Is there a quick way to check this? Like a registry setting or is there a file check I can do using the FileSystemObject?

Thanks for your help,

Sebastiaan.

you can call a dts package after the install to check if a file exists, then take action based on the results you are expecting.

This information will be useful.

http://www.sqldts.com/default.aspx?211


Jaime E. Maccou

You could always compare the installation log (not sure where they keep it any more) of a new system against a known good system.

Or...

Make a "golden" system that you know is 100% correct. Then, compare the files in that system with the files in your laptops. It's not perfect but it's better than a guess.

--Jeff Moden

Many thanks for the advice, have chosen to do some file checking using the FileSystemObject. For the Service Pack installation, it was easy to check for the version in the registry using the regread command in combination with the error object, if no key found it normally turned in error but when handled in a function [if error pops up], the result was just False.

... for the record.

Thanks for the feedback... forgot about the RegRead function.

--Jeff Moden