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.
Extensions in SSMS 21 - Database Administrators Stack Exchange
May 26, 2025 · It's, in truth, unlikely the extensions built for SSMS 20, or prior, will work on SSMS 21 without a release. SSMS 21 is based on the Visual Studio 2022 shell, which is 64-bit, unlike all prior …
Can I see Historical Queries run on a SQL Server database?
Someone was running a query on our SQL Server database remotely and their system crashed. They have no backup of that query and want to see what was run on the server. Is it possible to find this...
sql server 2012 - Manually entering data using Management Studio ...
May 20, 2013 · How can I enter data through the GUI interface rather than an insert command in SQL Server Management Studio 2012? I can't find it anywhere whereas there used to be an option in the …
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 Server, the only …
sql server - How can I compare the schema of two databases?
Mar 14, 2015 · 0 I'm a fan of SQL DBDiff, which is an open source tool you can use to compare tables, views, functions, users, etc. of two instances of SQL Server databases and generate a change script …
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 FQDN. …
sql server - Applying Quotes Across Multiple Lines - Database ...
In SQL Server Management Studio you can use the shortcut CTRL + K > C or CTRL + K > U to comment/uncomment lines in bulk. Is there a similar keyboard function that applies single quotes acro...
In SQL Server, how do I save the results of a query to a txt file?
Nov 29, 2022 · A manual way of achieving it is to CRTL+T on your SSMS to enable the option Results to Text. Execute your query and right click the Results > Save results as > Save as Type > All Files and …
sql server - How to add the Debug button to SSMS v18? - Database ...
Oct 30, 2018 · The Debug button is present on this version of SSMS: But it is not present on version 18, preview 4: I have tried in several ways to add the Debug button to my SSMS but not successful. Is …