New answers tagged ssms
just run a query that returns nothing select 1 where 1 = 2
This is not possible to do within the context of a single execution of whatever is in the Query pane. T-SQL commands are not interpreted by SSMS. They are sent to SQL Server to be processed. Only a GO [execution_count] statement (batch separator, GO being the default but can be changed) and a subset of the SQLCMD commands -- !!, :exit, :quit, :r, :setvar, :...
Run this query: SELECT ASCII(' ') AS [SingleSpaceString] , ASCII('') AS [NoSpaceString] You will note the the Value for [SingleSpaceString] is '32', while [NoSpaceString] is NULL. I'd suggest adding ASCII(Box.Ice) to your select statement to confirm that a true space is the value, vs. an odd character.
There is a bug in the SQL Server 2008 Upgrade system where even after upgrade, the system still shows the evaluation expiration message. This is resolved in SQL Server 2012 onwards.
For me it was the BitDefender firewall that made my SSM ultra slow Apparently, some sort of a firewall blocking for getting access to the database list
Go to Options and check Retain CR/LF on copy or save.
Do not fear everyone, I fixed my problem. What I had to do was detach the databases that I needed so that they were no longer being used by SSMS. This got rid of the error I was having and allowed me to add a connection to the data source in visual studio.
Team responsible for SMSS got separated and works with its' own development cycle. That means SMSS gets updated/released more often, and is independent from SQL Server releases. Licencing You've mentioned is probably another reason behind that (and a reasonable one, if You think about it), but what's the most important is that SMSS has got some much needed ...
SSMS is now a stand-alone product. Like most stand-alone product it will receive regular updates. This should ensure stability & give options to evolve the product over time.
SQL Server Management Studio is now available on its own page: SQL Server Management Studio - Release Notes Welcome to our generally-available release of SQL Server Management Studio! This release of SQL Server Management Studio (SSMS) is a stand-alone install outside of the SQL Server release. Our goal is to update this frequently with new ...
SQL Server Management Studio (2014) needs Visual Studio 2010 shell to run. You can re-install Visual Studio 2010 shell via the free download from Microsoft: https://www.microsoft.com/en-ca/download/details.aspx?id=1366
Go to Programs and Features, select SQL Server 2008 R2, and then the Remove option (people tend to panic that this will just remove everything without further input, but this merely launches a wizard): After this, you will be guided through a wizard much like installation. On the Select Instance screen, select the "remove shared features only" option: ...
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. https://msdn.microsoft.com/en-us/library/dn876712.aspx#bkmk_ga_instalpatch You may not need to uninstall 2016 to get this patch to work, but your mileage may ...
SQL Management Studio Unfortunately, there are some caveats that make using Application Intent in SQL Management Studio somewhat painful: To connect manually with ReadOnly intent, after bringing up the Connect to Server dialog from the Object Explorer, users must remember to: Click Options >>. Go to the Additional Connection Parameters tab. Enter ...
Yes you can. Use SQL synonyms https://msdn.microsoft.com/en-us/library/ms187552(v=sql.105).aspx By doing that you'll have a full control behind the curtains, but please fully document it and be consistent. It is a nightmare to troubleshoot databases with synonyms. As an alternative you can use dynamic SQL, it might be more transparent.
Top 50 recent answers are included