Activity overview
Latest activity by ejenkins
Thanks Jon! Yes we have the Filters check for Include All Roles enabled. However your suggestion to use SQL Compare of the database to SC helped narrow it down to the exact filter that was causing all roles, users and schemas to be "ignored". Here's a screenshot with the offending rule circled in red: [image] In summary we wanted to exclude all objects that belong to the tmp schema except for a table named PolMgrLoad. After removing the filter rule for "AND Object name Does not equal PolMgrLoad" roles and users appeared again in both SQL Compare and the Commit and Get Latest tabs! However this does mean we're no longer tracking changes for this one table we wanted to in our otherwise ignored tmp schema, but we can live with that. Seems to me as if that inner/sub AND conditional is correctly applied to many objects such as tables, functions, etc., but not others such as users, roles and schemas. / comments
Thanks Jon! Yes we have the Filters check for Include All Roles enabled. However your suggestion to use SQL Compare of the database to SC helped narrow it down to the exact filter that was causing ...
Roles not being tracked properly
Noticed recently that Roles are not showing up in either the Commit or Get Latest windows. Coincidentally we're also getting messages constantly about uncommitted dependencies when applying changes...
@swade it was just the release notes for a past update that fixed the issue. As long as you update your RedGate products, particularly SQL Prompt and SQL Source Control this specific issue shouldn't occur. / comments
@swade it was just the release notes for a past update that fixed the issue. As long as you update your RedGate products, particularly SQL Prompt and SQL Source Control this specific issue shouldn'...
...And an update is already out to fix the issue https://update.red-gate.com/updatecontrols/details.aspx?etc=575538536&guid=ca71d7aa-92da-44c7-a27e-b7ba34945d44&update=2695. Thanks Red Gate and kudos again to Vivan for finding the exact problem! / comments
...And an update is already out to fix the issue https://update.red-gate.com/updatecontrols/details.aspx?etc=575538536&guid=ca71d7aa-92da-44c7-a27e-b7ba34945d44&update=2695. Thanks Red Gate and kud...
Ah I missed "ProgramData"... Thanks!! / comments
Ah I missed "ProgramData"... Thanks!!
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me. / comments
Unfortunately I have no System.Data.SQLite.dll file in C:\Program Files (x86)\Red Gate\SQL Search 3 so this doesn't work for me.
Thanks for looking into it! Same issue here and this makes search entirely useless. / comments
Thanks for looking into it! Same issue here and this makes search entirely useless.