Activity overview
Latest activity by RichUchytil
Installing Toolbelt into SSMS 20 with SSMS 18 & 19 already installed
I've got SSMS 18 & 19 already installed and have the Toolbelt installed into both. I just downloaded SSMS 20 and am running the Toolbelt installer. It says there's nothing to install. How do I g...
Thanks, I'll do that. / comments
Thanks, I'll do that.
Formatting of OVER PARTITION and comma alignment
SQL Format has formatted my OVER PARTITION code like this:<div>COUNT(P.PRPR_ID) OVER (PARTITION BY P.NWNW_ID
,P.PRCF_MCTR_SPEC
...
Error SQLSearchSsmsPackage did not load correctly
I'm getting an error in SSMS v18.12.1 saying SQLSearchSsmsPackage did not load correctly. I looked at the ActivityLog.xml and no idea what any of that is telling me. Any ideas how to fix this? I...
Found the problem. I had COLLATION set for two of the columns in the table definition. Removed that and it deployed just fine. Originally I didn't have them and didn't have NULL/NOT NULL on every column. When it failed and I looked at the logs I saw NULL/NOT NULL on the columns and the collation stuff. So I added all of that to my code thinking the compare was looking for that stuff. Turns out I should have only added the NULL/NOT NULL stuff. It would be nice if the error message could give something more helpful to point to the issue instead of basically, "Sorry, it failed, go figure out why." At least now I know what to look for if it happens again. / comments
Found the problem. I had COLLATION set for two of the columns in the table definition. Removed that and it deployed just fine. Originally I didn't have them and didn't have NULL/NOT NULL on ever...
DevOps Post-update schema failure with Temporal Table
SQL Server 2016, Azure DevOpsAt the top of the logs:
2021-07-08T21:51:18.2089160Z ==============================================================================
2021-07-08T21:51:18.2089460Z Task ...