User profile for LouisSomers

When running the same command adding /verbose, the output shows this line three times: Event Aggregator: No registered listeners for RedGate.Compare.CommonUI.Shared.Events.FilterChanged The full log is included in the support ticket (268965). / comments

When running the same command adding /verbose, the output shows this line three times:Event Aggregator: No registered listeners for RedGate.Compare.CommonUI.Shared.Events.FilterChangedThe full log ...

0 votes

Hi Eddie, Thank you for your reply. Does this mean that we have to exclude all stored procedures and functions that use the table? Also all procedures and functions that use those procedures and functions recursively? I don't think this would be a viable solution. In my opinion there should be an option to have the .scpf file overrule dependencies (enabled by default). / comments

Hi Eddie,Thank you for your reply.Does this mean that we have to exclude all stored procedures and functions that use the table?Also all procedures and functions that use those procedures and funct...

0 votes

Thank you @Peter_Laws I posted a feature request on user voice. Running a post deployment script would work, but we are looking for ways to speed up deployment rather than slow it down. The problem with the excluded table in our .scpf file was that it was included again as a dependency. Disabling dependencies in addition to excluding the table seems to be the best workaround so far. / comments

Thank you @Peter_Laws I posted a feature request on user voice.Running a post deployment script would work, but we are looking for ways to speed up deployment rather than slow it down.The problem w...

0 votes

SQL Source Control is my favorite by far, Having the whole schema neat and tidy split up into separate folders and files, and being able to trace changes back to bugs or features, and see who implemented those changes, when and why... That's so valuable! Without this ability we would absolutely require to build regression test automation in order to solve bugs flipflopping each other over time (fix of bug A causes bug B and vice versa where the bugs would swap existence in following releases). Regression tests are great, but using the Annotate / Blame feature of a source control tool can provide a faster route and save a ton of time and confusion. / comments

SQL Source Control is my favorite by far, Having the whole schema neat and tidy split up into separate folders and files, and being able to trace changes back to bugs or features, and see who imple...

0 votes

Hi @Kendra_Little, thank you for your fast response, Yes the user had db_owner rights in the first example. In the 2nd example the user also had db_owner rights but then I explicitly checked "Deny" on "Alter any role" and "Alter any user" in the database properties -> permissions. The user only has db_owner rights on that specific database, not on the whole server. / comments

Hi @Kendra_Little, thank you for your fast response,Yes the user had db_owner rights in the first example.In the 2nd example the user also had db_owner rights but then I explicitly checked "Deny" o...

0 votes

The solution is to use the Filter.scpf file to exclude the user, and explicitly "override" the Filter.scpf file using the "Path to filter file" in the TeamCity build step. ("override" it with exactly the same file or else the filters will not apply at all). After that the user lives happily ever after! / comments

The solution is to use the Filter.scpf file to exclude the user, and explicitly "override" the Filter.scpf file using the "Path to filter file" in the TeamCity build step. ("override" it with exact...

0 votes

Maybe it will help if I provide a larger portion of the log, there's also a stack trace in there... The first part is successful, it runs SQLCompare.exe without any issue, the problems only start after it deletes the user it is logged in with. This is a domain user by the way. VERBOSE: C:\**TeamCityPath**\BuildAgent\plugins\sqlchangeautomation-teamcity-agent\Modules\SqlChangeAutomation\4.3.21056.24410\SC\SQLCompare.exe ended with exit code 79 VERBOSE: SQLCompare.exe completed successfully. VERBOSE: Altering schemas VERBOSE: Dropping users WARNING: The error 'The server principal "**DOMAIN**\**USERNAME**" is not able to access the database "**DBNAME**" under the current security context.' occurred when executing the following SQL: @ERROR <> 0 SET NOEXEC ON WARNING: The error 'The server principal "**DOMAIN**\**USERNAME**" is not able to access the database "**DBNAME**" under the current security context.' occurred when executing the following SQL: DROP USER [**DOMAIN**\**other_user**] WARNING: The error 'The server principal "**DOMAIN**\**USERNAME**" is not able to access the database "**DBNAME**" under the current security context.' occurred when executing the following SQL: @ERROR <> 0 SET NOEXEC ON WARNING: The error 'The server principal "**DOMAIN**\**USERNAME**" is not able to access the database "**DBNAME**" under the current security context.' occurred when executing the following SQL: DECLARE @Success AS BIT SET @Success = 1 SET NOEXEC OFF IF (@Success = 1) PRINT 'The database update succeeded' ELSE BEGIN @TRANCOUNT > 0 ROLLBACK TRANSACTION PRINT 'The database update failed' END Invoke-DatabaseBuild : Failed to clean the database '**DBNAME**' on server '**DBSERVER**'. Error: 4 batches failed. The first error is 'The server principal "**DOMAIN**\**USERNAME**" is not able to access the database "**DBNAME**" under the current security context.' Stack Trace: at RedGate.Versioning.Automation.Compare.SqlProcessing.SqlExecutor.ExecuteBatches(IHaveConnectionString connectionString, IReadOnlyCollection`1 sqlBatches, Int32 commandTimeout, Action`1 logAction) at RedGate.Versioning.Automation.Compare.Compare.SchemaUpdater.Clean(ExistingDatabase database, CompareOptionArguments compareOptionArguments) Local parameters [connectionString = Data Source=**DBSERVER**;Initial Catalog=**DBNAME**;Integrated Security=True;Pooling=False;Trust Server Certificate=True;Application Name="SQL Change Automation"] At C:\**TeamCityPath**\BuildAgent\plugins\sqlchangeautomation-teamcity-agent\SqlCi.ps1:193 char:39 / comments

Maybe it will help if I provide a larger portion of the log, there's also a stack trace in there...The first part is successful, it runs SQLCompare.exe without any issue, the problems only start af...

0 votes

We got it working again by using "4.0.19246.10328" in the "Required version of SQL Change Automation" field. It was set to "Latest" previously. Does the automation update itself automatically? Everyone here denies updating anything on the server. / comments

We got it working again by using "4.0.19246.10328" in the "Required version of SQL Change Automation" field. It was set to "Latest" previously.Does the automation update itself automatically? Every...

0 votes

Thank you. It can be voted for at https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/38143162 / comments

Thank you.It can be voted for at https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/38143162

0 votes

I deleted an index and now my colleague's name is in the "Last changed by" column. There are no other changes and my colleague was astonished since he had not done anything on that table recently. Seems like there must be some kind of mapping issue? / comments

I deleted an index and now my colleague's name is in the "Last changed by" column. There are no other changes and my colleague was astonished since he had not done anything on that table recently.S...

0 votes

How can we help you today?

LouisSomers

Comments