Best Of
Re: SQL Prompt doesn't work when running SSMS as different user
I'm experiencing the same issue. Due to security, to access SSMS properly, I have to shift-right click SSMS and "Run as a different user." When I do so, the SQL Prompt menu is bare - same as reported by ed_waystar above. If I log in with my normal user, I get all the SQL Prompt menu choices. Any idea how to resolve this?
bryan_1
1 ·
SQL Prompt doesn't work when running SSMS as different user
This used to work for years, but now when swapping to another SSMS instance with another user SQL Prompt ceases to work and tells me I have an unlicensed trial on the second instance.
When I click "Manage License" and then "Log In" it tells me to use my browser, and nothing happens.
version 10.14.21.9884
SSMS v18.12.1
When I click "Manage License" and then "Log In" it tells me to use my browser, and nothing happens.
version 10.14.21.9884
SSMS v18.12.1
ed_waystar
1 ·
Re: SQL Prompt Refreshing very slowly, different query when connecting to DB
I wish it only took 6 minutes... It is taking more like 15-20 minutes on some of our Databases. Please fix this!!!!
ShaneG
1 ·
Re: Is there a way to ignore Constraints as to whether objects are the same/different?
SQL Compare has an option that allows you to ignore system generated constraint names:
Visit Edit project/Options and check "Ignore system named constraint and index names".
Visit Edit project/Options and check "Ignore system named constraint and index names".
David Atkinson
1 ·
Re: How to address resolve merge conflicts in the .sqlproj <DeployChangesExecutionOrder> line?
A little bit late to the game but I'm surprised no one mention in the previous version of SCA (probably 3) that this line contains line breaks between each programmable object whereas in the latest version all programmable objects are all in one line (pipe separated). This makes it impossible to merge if you have a lot of programmable objects versus the diff tool easily can tell the changes if each programmable object were in their own line.
I would still say that a user doing the merge can still be flawed so there for the answer by @Pete_Ruiz
to remove or leave the line empty and have SCA re-generate the order is the best answer (there is a button to generate in the project property screen) for my use.
No way are we going to go back to SQL Source Control, ReadyRoll (older SCA name) was the biggest win we came across when we went to Build2018.
I would still say that a user doing the merge can still be flawed so there for the answer by @Pete_Ruiz
to remove or leave the line empty and have SCA re-generate the order is the best answer (there is a button to generate in the project property screen) for my use.
No way are we going to go back to SQL Source Control, ReadyRoll (older SCA name) was the biggest win we came across when we went to Build2018.
ducman
1 ·
SQL Prompt 10.15.0.12121 Not Working in Visual Studio 2022
I'm running Visual Studio 2022 (Version 17.12.0) with SQL Server Data Tools (Version 17.12.78.0)
After installing the most recent update to SQL Prompt, I started receiving this error message when I open a database project in Visual Studio 2022:
A check of the error log revealed several messages related to UI libraries not loading:
Need help troubleshooting this issue. Thanks.
After installing the most recent update to SQL Prompt, I started receiving this error message when I open a database project in Visual Studio 2022:
A check of the error log revealed several messages related to UI libraries not loading:
| Unable to load extension at: C:\PROGRAM FILES\MICROSOFT VISUAL STUDIO\2022\PROFESSIONAL\COMMON7\IDE\EXTENSIONS\MICROSOFT\SQLEDITOR\VSIX\. Exception text: Microsoft.VisualStudio.ExtensionManager.InvalidExtensionManifestException: Element 'Installation' is missing required child element 'InstallationTarget' or child element value is whitespace. at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ExtractManifestData(PackageManifest manifest) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ReadPackageManifest(XmlReader reader) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl.ReadManifest(Stream manifestStream) at Microsoft.VisualStudio.ExtensionManager.ExtensionImpl..ctor(String path) at Microsoft.VisualStudio.ExtensionManager.InstalledExtensionImpl..ctor(String vsixManifestPath, IEngineHost engineHost, Boolean installedPerMachine, CultureInfo preferredCulture, IList`1 extensionPackVsixIds, IList`1 packageGuids) at Microsoft.VisualStudio.ExtensionManager.ScanModule.TryLoadExtension(ExtensionLocations location, String fullPath, String normalizedPath, InstalledExtensionImpl& installedExtension, Int32 retryCount, Int32 retryDelay, Int32 attempts). |
Need help troubleshooting this issue. Thanks.
DataJedi
1 ·
Re: Update has caused Prompt to stop working
Thanks for this. This resolved it for me too after trying the other posted suggestions.RobertZ said:For me this was solved by downloading the SQL Toolbelt Essentials installer from the RedGate website to update all packages. SQL Prompt itself did not need updating, but the overall Toolbelt update did resolve my issue with Prompt.
Downloaded toolbelt essentials installer from: https://www.red-gate.com/products/sql-toolbelt-essentials/entrypage/latest-essentials
Then updated the products that were flagged with updates (ignored any which would have triggered new trials).
Working again now thankfully!
tonywaddle
1 ·
Re: SQL Search in ADS
Redgate - can we please get a definitive update on this? Is SQL Search extension in ADS abandoned? It appears to be, as the download URL is dead (https://www.redgatefoundry.com/SQLSearch). Please advise.
Microsoft Fabric support?
Are there any plans to support Microsoft Fabric warehouses in SQL Prompt?
dpurdy
1 ·
SSMS 21 Preview 1 Support
I know it only came out yesterday, but what are Red-Gate's plans for supporting SSMS 21?
IanKeogh
2 ·
