cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
TimStVCS
Level 7

InstallScriptMSI - Custom SQLServerSelectLogin2

Hello, I have an InstallScript MSI project in which I would like to make some customizations to the behavior of this dialog box. Specifically, I would like to control the population of the database catalog browse button to include only databases that I select. This would be databases where my companies application has been installed - basically excluding extraneous databases like AdventureWorks, Northwind, etc.

I would appreciate any pointers on how or if this could be done!

Tim
Labels (1)
0 Kudos
(2) Replies
hidenori
Level 17

One thing you can do is to specify a custom query for the QueryDatabasesCmd column of the ISSQLDbMetaData table in your InstallShield project using the Direct Editor. It is the T-SQL statement that InstallShield runs to get database catalogs, and the default value is "select name from master.dbo.sysdatabases".

Hope that helps.
0 Kudos
TimStVCS
Level 7

Thanks hidenori, I think this will work nicely!

Tim
😄
0 Kudos