Problem installing Adobe Flash CS3 30-day trial on Vista

On my lovely Vista machine I recently downloaded the Adobe Flash CS3 30-day trial, extracted the files, double-clicked 'Setup.exe' and sat back and waited to be prompted for an install location.

I was shown the following for about 5 seconds and then it disappeared and nothing ...

... so I tried again, this time watching the process appear in the Windows Task Manager | Processes list ... and then disappear again ... hmmm

Eventually I tracked down the solution in the Adobe Forums and it turns out that the Microsoft JScript Library needs to be manually registered like so:

- Open a command prompt (run as 'administrator')
- Type: cd "%systemroot%\System32" and press Enter
- Type: regsvr32 jscript.dll and press Enter
- You should get a dialog box saying "DllRegisterServer in jscript.dll suceeded.", click OK

Now when you run 'Setup.exe' the installer will run successfully.

AUTO_CLOSE enabled by default for SQLEXPRESS

Just had problems with the WebPoll database randomly disappearing and crashing the application.  It runs on an instance of SQLEXPRESS which, I have just found out, has AUTO_CLOSE enabled by default.

AUTO_CLOSE closes the database when the last user closes his or her connection and all processes in the database have completed. When a user then tries to connect to the database, SQL Server reopens the database, generating the following message in the Application Event Log:    Source: MSSQL$SQLEXPRESS     Description: Starting up database 'WebPoll'

Leaving this enabled on a regularly accessed database such as WebPoll will cause delays as SQL Server is constantly closing and reopening the database, it probably consumes a lot more resources as well. To turn off AUTO_CLOSE run the following script:

ALTER DATABASE [WebPoll] SET AUTO_CLOSE OFF

nb AUTO_CLOSE is disabled by default for other versions of SQL Server