Hot answers tagged

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


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


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.


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


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


1

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


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.


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


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.



Only top voted, non community-wiki answers of a minimum length are eligible