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 …
Can I see Historical Queries run on a SQL Server database?
Jamie Thomson points where SSMS actually has a "recovery" area under your Windows profile, similar to Word or Excel recovery. Another individual notes in comments about the SSMS …
ssms - SQL Server Management Studio cannot connect because of …
Feb 5, 2019 · Since the version of SQL Server you are trying to connect to doesn't support a version of TLS that is enabled on your system, the connection fails. If you can't upgrade SQL …
How to connect to a local SQL Server instance by IP Address in …
Nov 18, 2020 · In your SQL Server Configuration Manager if you scroll down to the bottom you will find the TCP dynamic Port that is being used by your local instance. With this information I …
sql server - Blue icon with question mark - what does it mean ...
Jun 19, 2017 · Adding an entry for the SQL server to your hosts file (C:\Windows\System32\drivers\etc\hosts) with the IP address and just the server name, not …
SSMS error - Database Administrators Stack Exchange
Jun 7, 2023 · I believe this happens when your SSL certificate for the SQL Server machine is not setup properly. You should be able to workaround it by checking off the "Trust server …
sql server - Is there a simple way to add a read-only user?
Aug 24, 2021 · 13 I have a hosted (shared) SQL Server database and I'd like to add a read-only login. (This login will be used to build Power BI data visualization.) Looking into this, it's far …
Extensions in SSMS 21 - Database Administrators Stack Exchange
May 26, 2025 · SSMS 21 is based on the Visual Studio 2022 shell, which is 64-bit, unlike all prior iterations which are 32-bit. Microsoft have also added support for native Visual Studio …
I can't connect to my servers SQL database via an IP Address
Mar 31, 2014 · When you install SQL Server as named instance it uses dynamic TCP/IP ports by default, so it is not possible to connect to it whitout specifying instance name (just IP address).
sql server - What does a RED X on a database user mean?
Jul 24, 2018 · I created two new AD groups and added them as Users of a database, but their icons show with a red X. What does this mean?