It would be nice to have the ability to set default values for custom properties, outside of modifying the database columns directly. While we are able to work around this, we are at risk of losing support when performing upgrades etc. Not having default values results in NULL for columns of type nvarchar. Any alert trigger queries that contain logic around that property can create some undesired results, for example

select *

from nodes

where CustProp1 <> "BadNode"

will return 0 nodes even if the table has 50 rows with a value of BadNode in the custom property and the other 50 rows with NULL.

Actions

More Like This

Incoming Links

SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining.

SolarWinds uses cookies on its websites to make your online experience easier and better. By using our website,
you consent to our use of cookies. For more information on cookies, see our cookie policy.