When we drag something from OE into a query window, then the identifier will always be enclosed in square brackets. Many of us do our due diligence and take care to use identifiers that do not require separators. These separators makes SQL code (a lot) harder to read, and we feel that we are punished with these square brackets. We don't want to do a search and replace all over and over again, when there could just be a setting in SSMS to not generate these.

The DELETE key does not work as expected when trying to rename a database object in Object Explorer. The BACKSPACE key works correctly.

When you enable the parameter "SET SHOWPLAN_TEXT ON; " The first query execution goes well and produces a query plan in text format, but the second one causes an error at the level of "mscorlib "

In SQL Server Management Studio 2008 RC0, when you enter "newsequentialid()" as the "Default Value or Binding", SSMS gives a dialog box that says "Error validating the default for column XYZ. Do you want to cancel your changes?"

This error message occurs whether or not you have set the RowGUIDCol property on the xolumn.

I have seen similar feedback items, mostly for SQL 2005, but there seems to have been no resolution in several years. I hope this can get fixed for SQL 2008.

When adding a database that has case sensitive collation to Availability Databases (SSMS -> Always On High Availability -> Availability Groups -> Group Name) it will fail with the following error: "The multi-part identifier "a.delimited" could not be bound".

In Management Studio V17.4 me and my colleague both gets the error "Input string was not in a correct format. (mscorlib)" when we have first executed the SET SHOWPLAN_ALL ON statement and do a simple select like SELECT * FROM sys.objects afterwards

This works in SQL 2016, so something must be broken in SQL 2017

When trying to enable page compression on an index through the GUI (SSMS 17.4), I get the following error: "Object reference not set to an instance of an object".

Hi, can anyone tell me when security patches for the meltdown/spectre vulnerability will be made available within the Microsoft update catalog? I would like to push them down Via wsus but cannot do this due to them now being added into the catalog or wsus.

KB4057121 for 2012

KB4057113 for 2008 R2

thanks

Lee

The word "specified" is spelled incorrectly of line 79 of the Simple Database Mail Configuration Template on SSMS 17.4.

The line reads "RAISERROR('Failed to associate the speficied profile with the specified account (<account_name,sysname,SampleAccount>).', 16, 1) ;"

The SSRS CSV renderer does not respect Row Visibility. So if a row in a tablix is suppressed with a Visibility expression, it does not export to other formats like PDF or Excel, but the row DOES export to CSV, so the data does not match up to what is on the report in other formats. BAD!

Although SQL Server 2017+ (Windows and Linux) management packs for SCOM exist, there seems to be no SQL Server 2017 Reporting Services (Native mode) or SQL Server 2017 Analysis Services management packs for SCOM available yet. When will this be rectified? (See MP wiki screenshot - all other SQL versions have AS/SSRS management packs).

It does not appear to be possible to disable telemetry that is part of Reporting Services 2017 (version 14.0.600.689) via Microsoft.ApplicationInsights.dll. The cookies ai_user and ai_session are set and requests initiated to MS-owned cdn web pages.

Options that exist for the independently distributed ReportViewerControl (available via NuGet) do not appear to apply to Standalone SSRS 2017.

I am also using a custom Forms authentication setup.

See also https://social.msdn.microsoft.com/Forums/sqlserver/en-US/e6fd0eb7-2e6a-4818-a1bc-d18d3be89e73/how-to-disable-telemetry-for-ssrs-2017?forum=sqlreportingservices.

For the longest time I've been running SQL Server 2017 GA in Ubuntu 17.10. But, recently, after a recent apt update/upgrade to the OS, it stopped working.

I can't find any documentation to rebuild the system databases as the message I'm getting from the log in the image provided.

It would be nice to have an option as "/ACTION=REBUILDDATABASE".

If subquery fails with
"Msg 207, Level 16, State 1, Line 16
Invalid column name"
all data is returned from the outer query.

if object_id('justnow','U') is not null drop table justnow
if object_id('string','U') is not null drop table string
go

select getdate() somedate
into justnow
go

select 'xyz' txt
into string
go

select *
from justnow
where somedate in (select somedate from string)
go

I'm getting this error when deploying a dacpac using the nuget version of DacFx.

The dacpak in question is very simple - one sproc, one table, a pre and post script (both empty).

This deploys fine if I use either sqlpackage.exe (17.4.0 GA DacFx) or Visual Studio Data Tools 2017 (latest version). It is just an issue with the library.

(Full stack trace and sample Powershell code in attachment)

When adding a database to an availability group, one must perform a full backup, before meeting the prerequisites.
However, once you do this, the wizard just performs another full backup anyway.
This seems redundant.
Why not just let the wizard do this, and not make it a requirement, as it's going to happen anyway?

On SQL Server 2008 (SP1), when a column name contains the dot character, it is not included in the schema rowset of the respective table when requested via both the SQLOLEDB and SQLNCLI10 providers using ADO's OpenSchema(adSchemaColumns) method. The SQL Server Profiler shows that a command similar to the following is issued on the server:

[testdb].[sys].sp_columns_100_rowset N'tab',N'dbo',NULL

When executed, this command returns rows for all columns except those which contain the dot character in their name. On SQL Server 2005, it works as expected.

Ales

Connection Properties are not retained when servers are registered under a Central Management Server.

I have tested the "Connect to database:" and "Use custom color:" properties and neither retain there settings after reconnecting to or refreshing the Central Management Servers. I would expect that these settings would be stored on the CMS to enable setting these properties centrally for consistency.