
Is there a way to see the code that creates a view in SQL server ...
Dec 5, 2016 · I want to see the underlying code for how a view is created in SQL server management studio. Is there a way to do this? I want to see any date filters, etc, applied to this view in hard code.
How can I fix "Login failed for user sa" error in SQL Server?
Apr 30, 2021 · 8 I can access my databases through SQL Server Management Studio (SSMS) by using my Windows account no problem. I have two issues though: I want to enable sa and then try to log in …
sql server - IntelliSense not working but it is enabled - Database ...
This problem is really proving to be a tricky one (and quite annoying). In SQL Server Management Studio 2008, up until a few days ago my IntelliSense was working great. Then all of a sudden it st...
How to recover missing SQL auto-recover files in SSMS (Microsoft SQL ...
Sep 12, 2021 · SQL Server Management Studio (SSMS) closed unexpectedly. Many SQL files were open. When SSMS was restarted, it did reopen some auto-recover files, but not all of them, …
SQL Server Management Studio (SSMS) is way too slow in its GUI
Sep 21, 2019 · Try setting the RAM manually in MS SQL Server Management Studio -> Right Click the SQL Server in Object Explorer -> Properties -> Memory. I set my min memory to 1000 MB and the …
SQL Server Management can't find Local Server on fresh install
Sep 3, 2021 · I am currently studying SQL Database management, so I am new at this. I have installed SSMS on a fresh copy of a Windows 2019 Operating System running on Hyper-V lab testing …
Enable Toolbox window in SQL Server Management Studio
Mar 26, 2021 · Using SSMS v17.9.1 and the only add-in installed in SQL Prompt 8. The only workaround that works is clicking on the entry, Ctrl+C, then pasting it into the editor.
sql server - How do I modify the user interface language in SSMS ...
How do I modify the user interface language in SQL Server Management Studio? For instance, if I installed in English, but wish to view in Japanese (to name but one possible example).
sql server - Save Connections in SSMS? - Database Administrators …
Can I save some sort of session or profile in SSMS (2008 r2) that will open up connections to a saved list of database servers when I open SSMS? So for example I frequently will open up SSMS and ...
SQL Server Management Studio 2012: How to have folders in the SSMS ...
Nov 23, 2012 · 25 I'm using SSMS 2012 to talk to the SQL server 2012 and Azure SQL servers we use. I admit I'm not a SQL expert so I've been saving most of my SQL scripts for future reference. I've …