#14580: SQL SERVER 2016: Extra Line is displayed in preview sql tab when we alter database.

Diksha.kushwah(*) reported 2016-07-28T13:48:07Z · rachanag(*) last modified 2017-01-03T11:45:55Z

SQL SERVER 2016: Extra Line is displayed in preview sql tab when we alter database.

Dev	tomconrad
QA	ivangron

Priority	Major
Complexity	Unknown

Component	Script Object
Version	18.0

Version: 18.0.0-devi-191

Build #: 50630

Build Date: 2016-Jul-27 05:07:00 PM

Operating Environment: Windows 7 (6.1, amd64) / Cp1252 / en / US / Oracle Corporation 1.8.0_72-b15

Memory: Max=954,728,448; Total=409,468,928; Free=315,380,904; CPUs=8

Steps to reproduce:

1. Connect to SQL SERVER 2016

2. Execute following query in QA:

CREATE DATABASE [Test]

CONTAINMENT = NONE

ON (NAME = N'Test_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\DATA', SIZE = 8192KB, MAXSIZE = UNLIMITED , FILEGROWTH = 10%)

LOG ON (NAME = N'Test_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL13.MSSQLSERVER\MSSQL\DATA\Test_Log.mdf', SIZE = 5120KB, MAXSIZE = UNLIMITED , FILEGROWTH = 10%)

COLLATE Albanian_CI_AI_KS

WITH

FILESTREAM (NON_TRANSACTED_ACCESS = OFF, DIRECTORY_NAME = N'diksa'),

DB_CHAINING ON,

TRUSTWORTHY ON

3. Right click on Database "Test" and select Alter database

4. Rename the Database name "Test" to "Test1"

5. Switch to preview sql tab

Actual Result: following script is displayed under preview sql tab:

ALTER DATABASE [Test] MODIFY NAME = [Test1]

ALTER DATABASE [Test1] SET COMPATIBILITY_LEVEL =

Expected Result: ALTER COMPATIBILITY_LEVEL line should not be displayed when we did not change the COMPATIBILITY LEVEL.

3 attachments

Alter_database.png

2016-07-28T13:52:38Z

9 KB
verify-devi-211.png

2016-08-25T05:13:45Z

10 KB
Verified_#14580.png

2017-01-03T11:45:55Z

10 KB

All Comments (7) Change History

tariqrahiman 2016-07-29T18:42:59Z

What is the behavior with prior versions of ADS ? v17 or v16 ?

Diksha.kushwah(*) 2016-08-01T10:33:58Z

In v17 and v16 only "ALTER DATABASE [Test] MODIFY NAME = [Test1]" line is display when we rename the database.

In v18 "ALTER DATABASE [Test1] SET COMPATIBILITY_LEVEL =" line is present in preview sql tab even we don't change anything.

SachinPrakash 2016-08-01T20:35:34Z

@diksha: pls investigate whether this issue is specific to SQL Server 2016 or occurs based upon earlier versions? Also, determine which ADS build # did this problem first start to occur

Diksha.kushwah(*) 2016-08-02T11:59:44Z

This issue occurs only for SQLSERVER 2016.

In v17 same behaviour observed for SQLSERVER2016.

tomconrad 2016-08-23T22:22:56Z · (edited)

svn# 50920

Hi Diksha,

This error occurs because we added 2016 version of MSSQL to ADS V18. The compatibility level now changes to 130. We do not support 2016 version in V17 so I don't think we need to retrofit it.

Thanks, Tom

Diksha.kushwah(*) 2016-08-25T05:14:58Z

Verified in ADS 18-Devi-211

rachanag(*) 2017-01-03T11:45:16Z

Verified in ADS v18-rc-15

Please refer attached Verified_#14580.png

Search Tips

Aqua Data Studio / nhilam

SQL SERVER 2016: Extra Line is displayed in preview sql tab when we alter database.

3 attachments

Issue #14580

Completion

1 issue link

Issue #14757

Search Tips

Aqua Data Studio / nhilam

Title

SQL SERVER 2016: Extra Line is displayed in preview sql tab when we alter database.

3 attachments

Issue #14580

Completion

1 issue link

Issue #14757