No announcements
-
0 Votes
The configuration registry key could not be opened (0x800703F3)
I have two versions of VS 2017 installed - VS 2017 Enterprise and VS 2017 Enterprise Preview. When trying to install SSDT 15.6.0 I run into two issues: 1) When it ...Answered | 10 Replies | 105 Views | Created by Travis Illig (FISV) - Monday, April 23, 2018 9:19 PM | Last reply by Travis Illig (FISV) - 10 hours 28 minutes ago -
1 Votes
Object transfer error - An exception occurred in SMO. Value cannot be null. Parameter name: server
Hey folks, I've used the transfer objects task with previous versions and never run into this issue, so any help would be much appreciated. When executing ...Proposed | 6 Replies | 279 Views | Created by dedbeat - Wednesday, February 21, 2018 4:05 PM | Last reply by dedbeat - 10 hours 40 minutes ago -
0 Votes
SSDT for sql server 2016
Hi, I have Visual studio 2015 professional installed in my system. And now I am planning to install SQL server 2016. Do I have to install SSDT for sql server 2016 again after ...Unanswered | 1 Replies | 16 Views | Created by Vijay.krishna24 - 12 hours 20 minutes ago | Last reply by Sarat (SS) - 12 hours 8 minutes ago -
1 Votes
Unable to create a file group that CONTAINS MEMORY_OPTIMIZED_DATA, when publishing an SSDT Project
I am using Visual Studio 2013 updated 5, with latest SSDT update installed. I have an SSDT Project , target platform set to "SQL Server 2014" and compatibility level set to "SQL Server ...Unanswered | 4 Replies | 769 Views | Created by Sanil Mhatre - Tuesday, May 24, 2016 6:40 PM | Last reply by Jean-Chris - 13 hours 4 minutes ago -
0 Votes
Cannot install SSDT 2017 in English Language
Hello, I recently installed SSDT 2017 using the web installer I downloaded from MS website, I specifically chose to download English (US) with SSDT-Setup-ENU.exe. However, the ... -
0 Votes
SSIS 2015 and Could not retrieve the table information for the connection manager ‘Excel Connection Manager’
Hi to all, we've got a Windows Server 2012 R2 with SSIS 2015 installed, and also SAP BO BI 4.2. There is also Office 2016, and we first tried (and then ... -
0 Votes
Why does SSMS say "Executing Query" when you click "Parse"?
And can this be changed? I'll parse larger scripts, but when they run for a bit and I have to turn attention elsewhere, I sometimes dont remember that it was ...Unanswered | 1 Replies | 21 Views | Created by Andrew Stanton - Tuesday, April 24, 2018 5:20 PM | Last reply by Sarat (SS) - Tuesday, April 24, 2018 6:59 PM -
0 Votes
Where can I find AdventureWorks for SQL Server 2008?
Hi. I want to install AdventureWorks for SQL Server 2008 but I cannot find it anywhere. I went to the codeplex archive and found a link to a github repository but it doesn't contain a version of ...Unanswered | 4 Replies | 56 Views | Created by NentoR 开发人员 - Monday, April 23, 2018 2:08 PM | Last reply by Simple Samples - Tuesday, April 24, 2018 6:07 PM -
5 Votes
Unable to Preview Oracle OLE DB Source in SSDT 17.2/VS2015
When using SSDT for VS2015 (17.2), I'm unable to preview any OLE DB data sources that use the Oracle OLE DB provider installed as part of the Oracle client. I've tested this on a ...Unanswered | 12 Replies | 1104 Views | Created by emorgoch - Tuesday, September 12, 2017 8:01 PM | Last reply by emorgoch - Tuesday, April 24, 2018 3:52 PM -
0 Votes
System DMV's missing from SQL Server 2017 master.dacpac in SSDT 2015
I originally asked this question over on Stack Overflow (link) and it was suggested I raise it here. To summarise; I have a database project with a reference to the ... -
0 Votes
Trying to create a check constraint using "WITH CHECK" but generated script has "WITH NOCHECK".
A new table was added to my SSDT database project that contains a check constraint which we require to be create "WITH CHECK". However we are only able to get a generated script from ...Proposed | 2 Replies | 726 Views | Created by StevenIBSI - Wednesday, October 07, 2015 7:59 PM | Last reply by mikal.k.grant - Monday, April 23, 2018 7:50 PM -
0 Votes
Why is SSDT Schema Compare showing difference in DefaultExpressionScript?
While comparing Database instance to a Database project in VS2010 using SSDT, it shows a difference in one of the Stored Procedures. The Store Procedure DDL script is exactly the same (with 1 ...Unanswered | 4 Replies | 793 Views | Created by Ross Brigoli - Tuesday, October 13, 2015 9:58 AM | Last reply by shall219 - Monday, April 23, 2018 4:15 PM -
0 Votes
SQL71561 Computed Column has an unresolved reference to object, even though reference exists
I'm having trouble getting references working for a database project in VS2017 for SQL Server 2012 The primary database in the solution, DOFSHR, has a reference ... -
0 Votes
Roadmap for SSDT?
There hasn't been a single blog post in the SSDT forum since April of last year and I'm assuming no releases since then. Is SSDT a product that is still undergoing continued development? I'm speaking ... -
1 Votes
Phantom tables in SSAS cube data source view
I'm trying to create an SSAS multi-dimensional cube using Visual Studio 2015 with SSDT 17.3. What's happening is that the Data Source View in the cube designer is showing several ...Unanswered | 9 Replies | 532 Views | Created by emorgoch - Tuesday, November 28, 2017 5:52 PM | Last reply by DSqlAnalytics36 - Friday, April 20, 2018 6:10 AM -
0 Votes
Schema and Data compare for PDW
I'm trying to compare two databases, one on SQL 2008 and the other on PDW AU3. I'm able to successfully connect to the databases. However, on trying to compare, it ...Proposed | 2 Replies | 572 Views | Created by Shiraine - Sunday, August 30, 2015 9:05 AM | Last reply by Carlos CaPe - Thursday, April 19, 2018 8:28 PM -
0 Votes
SSDT and MSBUILD and SQLCMD variables
How do I escape this?: .$msbuild /t:Build /t:Publish /p:TargetDatabaseName=$Database /p:TargetConnectionString=$connectionString /p:SqlPublishProfilePath=$SettingsFileName ... -
0 Votes
Utility Explorer is missing on SQL Server 2017 17.6
Only 3 days ago I installed without any problem, the version of SQL SERVER 2017, 17.6 and it worked well during the first day. The next day, the Utility Explorer window (Object ... -
0 Votes
overlapping options, letter too small...
Hi experts, This is one of the many annoying things I get with SSDT… As you can see the ‘mining model’ is overlapped by Decision tree.. I ... -
26 Votes
SQL71006 - Why Am I Getting This Error?
I have the following table defined in my SQL ...Answered | 7 Replies | 21763 Views | Created by Randy Minder - Monday, February 11, 2013 7:16 PM | Last reply by GaneshGontina5k - Thursday, April 19, 2018 1:58 PM - Items 1 to 20 of 3920 Next ›
No announcements