Activity overview
Latest activity by tvanharp
Dan, Seems to be fixed now. What I did that seemed to change this was to open SSMS under my normal account and created a custom style. Then restarted SSMS and it stuck. Then re-booted and it stuck. Then checked my alternate account and that one was stuck as well, not sure why. I deleted the style from my regular account and launched SSMS as my regular account and obviously that one went back to default. I restarted SSMS under my alternate account and it stuck as well same after a reboot and same after installing the prompt update. Nothing I do seems to cause it to revert back to the redgate default. So I'm calling it fixed but have no clue as to why. / comments
Dan,Seems to be fixed now. What I did that seemed to change this was to open SSMS under my normal account and created a custom style. Then restarted SSMS and it stuck. Then re-booted and it stuck. ...
After a restart I go into edit formatting styles and this is what I see: The directory matches the prev posts but the style has switched back to redgate Default. [image] / comments
After a restart I go into edit formatting styles and this is what I see:The directory matches the prev posts but the style has switched back to redgate Default.
[image] [image] here's the file for the style I created. [image] / comments
here's the file for the style I created.
So the account I normally sign in as doesn't even have a directory because I never use that account when opening SSMS I always do a run as different user. I logged in locally with that other account so I could see the settings. Here they are: [image] / comments
So the account I normally sign in as doesn't even have a directory because I never use that account when opening SSMS I always do a run as different user.I logged in locally with that other account...
I've been holding off on updating to 10.8.2 as I wanted to see if that causes the style switch, but I just noticed it switched again on its own and yes it goes back the RedGate Default style. Seems to switch every time i close SSMS. I just reset it back to my default and confirmed it formatted a query correctly. I closed SSMS and opened it and now it's back to the redgate default. Is there a setting file somewhere that is not being updated maybe? Here's the other version info from SSMS if maybe that will help. SQL Server Management Studio 15.0.18386.0 SQL Server Management Objects (SMO) 16.100.46437.65 Microsoft Analysis Services Client Tools 15.0.19618.0 Microsoft Data Access Components (MDAC) 10.0.18362.1 Microsoft MSXML 3.0 6.0 Microsoft .NET Framework 4.0.30319.42000 Operating System 10.0.18363 / comments
I've been holding off on updating to 10.8.2 as I wanted to see if that causes the style switch, but I just noticed it switched again on its own and yes it goes back the RedGate Default style. Seems...
Also is it possible there is a shortcut key or something that switches styles? Maybe it's something I'm doing. / comments
Also is it possible there is a shortcut key or something that switches styles? Maybe it's something I'm doing.
Morning Dan, Current version is 10.8.1.23216 Not sure what style it reverts to, guessing Default, never really looked I just go in and change back to my custom style and not sure if any other setting revert. The main thing I notice is when commas are after the list value and not before, can't say what else might have changed. I've created a new custom style, then deleted both and created a new one to see if that helped. Then when it happened again I posted the issue here. I also normally update as soon as I get prompted that there is an update, but not the last one, thinking maybe that is why it reverts back. I may not use the format option a lot depends what I'm doing so it's possible it only happens when I apply an update. Can't say for certain. I could apply the latest and see if it reverts. I log in as an account different from what I'm logged in on my computer. I choose Run As Different user when launching SSMS, but always the same user. Thanks, Tom / comments
Morning Dan,Current version is 10.8.1.23216Not sure what style it reverts to, guessing Default, never really looked I just go in and change back to my custom style and not sure if any other setting...
Why do my SQL Prompt settings keep reverting back to the default??
I'm not sure what triggers this but very often I need to into SQL Prompt options and re-apply my custom style. What do I need to do to have these settings stick all the time. It's very annoying and...
Having the same issue, it appears that this was caused by installation of Team Foundation Services 2008.
DLL location was also not correct like others mentioned the following is the command I used. regsvr32 "C:Program Files (x86)Common Filesmicrosoft sharedMSEnv extmgrp.dll"
Note: When launching cmd window use shift+RightClick and choose run as admiinistrator
The error I got on the first try was:
<DLL file> was loaded but the call to DllRegisterServer failed with error code 0x80070005 / comments
Having the same issue, it appears that this was caused by installation of Team Foundation Services 2008.
DLL location was also not correct like others mentioned the following is the command I used....