Activity overview
Latest activity by Bugmeister
Database name "like" filter for "Database Unavailable" alert?
Hi,I'm very new to SQL Monitor so maybe I'm overlooking something obvious. Our environment consists of several applications which periodically drop databases, i.e. an reporting application which s...
SQL Source Control Certificate Object Signing
Hi,Some of our objects are signed by a certificate (to elevate running permissions to the corresponding certificate user) which is done via a "ADD SIGNATURE TO ?.? BY CERTIFICATE [?]" statement.Is ...
OK that's an idea Alex. Only downside is we'd have to remember (or I guess it could be automated) to include any changes (i.e. it wouldn't be caught by SSC's "Commit" tab if a change was made to the trigger in-DB). / comments
OK that's an idea Alex. Only downside is we'd have to remember (or I guess it could be automated) to include any changes (i.e. it wouldn't be caught by SSC's "Commit" tab if a change was made to t...
Source control a trigger on a table but not the table structure
Hi,I thought I'd asked this before but perhaps not. On a 3rd party database we'd like to source control out enhancements/modifications but not the vendor-supplied objects. Therefore we filter out ...
Thanks Dan. Filtering extended properties by name seems work ones that are against the database itself (at least when we've done it in the past). Do you think it's a bug/issue that it doesn't work the same way for ones against stored procedures? / comments
Thanks Dan. Filtering extended properties by name seems work ones that are against the database itself (at least when we've done it in the past). Do you think it's a bug/issue that it doesn't wor...
OK Dan I haven't seen a reoccurrence since but if I do I'll raise a support ticket. Thanks. / comments
OK Dan I haven't seen a reoccurrence since but if I do I'll raise a support ticket. Thanks.
Order of changes? Altering tables before stored procedures that reference them?
Hi,I had a CI failure today because in the SCA update script a stored procedure ALTER was done before an ALTER TABLE to add a column that the procedure now referenced.How is the order of changes wo...
Filtered out extended property being included in object script
Hi,If I exclude an extended property by name via the filter, should that prevent the extended property being included in any object scripts that have the property against them? I.e. if I have a st...
Ok cool, that was at the back of my mind as well and is likely the way we'll go but it was worthwhile checking I wasn't overlooking something more obvious or easier. Thanks. / comments
Ok cool, that was at the back of my mind as well and is likely the way we'll go but it was worthwhile checking I wasn't overlooking something more obvious or easier. Thanks.