New answers tagged

1

just run a query that returns nothing select 1 where 1 = 2


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, :...


3

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.


1

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.


-1

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


0

Go to Options and check Retain CR/LF on copy or save.


0

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.


2

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 ...


1

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.


15

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 ...


0

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


4

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: ...


0

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 ...


1

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 ...


0

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