SQL Express CU5 Installation

HCL Domino Domino Forum
1

Please guide on this :

There is one button with code written as -

@Command( [Execute] ; “Q:\ABC\ABC 4.0 Production\SQL Express SP2 CU5\ATP_SQL_Server_2008_R2_Express_Update_SP2_CU5.exe” )

Requirement is - This button will be sent on mail to users and in this button only I need to add this condition -

  1. If CU5 is already installed, Installation should not proceed and should trigger a mail to XYZ saying already CU5 installed

  2. Else if CU5 is not updated, Should say kindly close Excel, Word(if they are opened). Once user clicks OK those processes should kill if still running in background and then it should copy the installer to local and then run from local(Restart may required). If possible mail should trigger to XYZ saying successfully installed.

Where Q: Drive in the Button refers to locational IP addresses in the example format below :

\10.10.100.100\Controls

Not used any such functionality before , please guide.

2

Subject: SQL Express CU5 Installation

You wont be able to do it with a @function command unless you write some other program that is going to let you know if the process is running.

For step 1 you can probably check the registry for a value to see if it is installed.

For step 2 you’re going to need to hook into the OS to see if a process is already running, there are no @functions to do that. So you would require either your own program that you call with an @command to do that, or maybe do it with Lotusscript hooking into a windows dll to check if a process is running. Doing a simple google search for “lotusscript process running” will find some examples of how to do that.