Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 97765

SQL Server Management Studio, a graphical front-end tool shipped with SQL Server for managing and querying databases. It also supports managing other bundled systems such as SSAS.

3
votes
No, there is no such option. SSMS doesn't open the database object and lock it down for you like Visual Studio w/ Data Tools add on does. Instead, it generates a sql script depending on what you … ask again, and it pops open a new window going thru the same as above. It is always giving you the information at the time of the request to SSMS. Visual Studio does the "Oh hey, you want the …
answered Aug 22 '16 by Anthony Genovese
1
vote
Add a semicolon after the middle block of code. I have noticed that sometimes it gets "stuck" trying to process something. Providing it with a clear break in a command seems to let it pick up again on …
answered Mar 21 '17 by Anthony Genovese
1
vote
0answers
Is it possible to hide tables or other objects from popping up on SSMS' IntelliSense? For example, I have the following tables Patient Patient_history Patient_daily I would like to only see patient pop up in my IntelliSense. Is this possible? …
asked Oct 26 '17 by Anthony Genovese
4
votes
1answer
When I try to install SQL Server Management Studio, Version 17.0, I receive the following error message: "The Generally Available (GA) version of SQL Server Management Studio (SSMS) v17.0 … cannot be installed because a pre-release version of SSMS is installed on your computer. Uninstall the pre-release version of SSMS from 'Add/Remove Programs' in the Control Panel and run SSMS setup …
asked May 9 '17 by Anthony Genovese
-3
votes
You need to make sure to follow all of the pre-install instructions as there are critical items that need to be followed for all SQL Server 2016 features to work correctly. You can see the list here. …
answered Jul 1 '16 by Anthony Genovese
3
votes
SSMS 2016 is available for free. It has much better IntelliSense than in previous versions. https://msdn.microsoft.com/en-us/library/mt238290.aspx I highly recommend upgrading. Other reasons why you …
answered Oct 5 '16 by Anthony Genovese