No announcements
-
2 Votes
SSDT Publish fails trying to create existing index
Critical show-stopper issue VS Version 16.3.5 SQL Server Data Tools - 16.0.61908.27190 After upgrading to the latest VS 2019 release yesterday, ...Unanswered | 3 Replies | 844 Views | Created by EricDAllen - Thursday, October 17, 2019 12:21 PM | Last reply by caseyboyle1986 - 6 hours 4 minutes ago -
0 Votes
How to disable right clicking on SSMS?? (security requirement)
How to disable right clicking on SSMS?? (security requirement) Regards, Ashif ShaikhUnanswered | 5 Replies | 189 Views | Created by Asif_DBA - Sunday, December 8, 2019 9:49 AM | Last reply by Dan Guzman - Sunday, December 8, 2019 2:52 PM -
0 Votes
Import Database failure message: One or more errors occurred.
In trying to import the database schema into a project, we encountered this error. What does it mean and where can we get more information about this error?Unanswered | 1 Replies | 305 Views | Created by cenko2 - Saturday, December 7, 2019 12:11 AM | Last reply by Vaibhav-Chaudhari - Saturday, December 7, 2019 6:11 AM -
1 Votes
sqlpackage cannot create graph tables in custom schema
Using the SSDT release 15.6.0 build 14.0.16162.0 errors out trying to create graph tables in a schema other than dbo. The error stats that the schema is not ...Unanswered | 1 Replies | 354 Views | Created by ipz-seand - Tuesday, April 17, 2018 6:26 PM | Last reply by Adam Joseph Stone - Friday, December 6, 2019 4:55 PM -
0 Votes
Bug: SSRS DAX Queries with parameters trigger error on save
Visual studio 2017, SSDT 15.5.1 Getting the below error when trying to create or modify a DAX query in SSRS designer that has parameters. Removing all parameter check ...Proposed | 3 Replies | 967 Views | Created by HW_J - Thursday, January 25, 2018 3:10 PM | Last reply by Lisa Kriel - Friday, December 6, 2019 11:00 AM -
0 Votes
Visual Studio 2019 Data Tools import package missing C# Script and variables
I installed Visual Studio 2019 and from the marketplace installed SQL Server Data Tools. I imported an SSIS package and all C# code and variables are missing. How can I get my code back?Unanswered | 1 Replies | 155 Views | Created by John Piraino - Thursday, December 5, 2019 10:01 PM | Last reply by Vaibhav-Chaudhari - Friday, December 6, 2019 4:57 AM -
0 Votes
SQL Server Import/Export Wizard Hangs in SSMS 2017
Greetings, I have recently upgraded to SSMS 2017 (v17.6) and seem to have found an issue with the Import/Export Wizard. Specifically, I am attempting to import a flat file (CSV); ...Unanswered | 2 Replies | 1015 Views | Created by CyberVinnie - Friday, April 6, 2018 2:15 PM | Last reply by David Millsom - Thursday, December 5, 2019 11:51 PM -
0 Votes
Publishing DB fails - object does not exist or is invalid for this operation
I have a DB project (in VS 2017) that was created from an existing DB. When I publish the DB I get the error that an object (a trigger) cannot be created because the object it is associated with ...Unanswered | 3 Replies | 540 Views | Created by Moe Codez - Tuesday, November 26, 2019 7:34 PM | Last reply by Guoxiong - Thursday, December 5, 2019 2:16 PM -
0 Votes
Security Row Filters in Visual Studio and Management Studio
Hi Al, I have been trying to setup security for users using Management Studio and Visual Studio. Doing this by using Row Filters. When I assign a ... -
11 Votes
SSDT Install "Setup Failed" Recursion too deep; stack overflowed 0x800703E9.
I have windows 10 and newest visual studio version. I have tried rebooting to make sure I have as many resources as possible. I have 4g ram Just for the record ...Proposed | 8 Replies | 21247 Views | Created by Bill Pennock - Thursday, March 8, 2018 12:03 AM | Last reply by Steve Siggs - Thursday, December 5, 2019 1:37 PM -
0 Votes
SSMS Data Export Wizart doesn't transfer identity column or primary key
Using the SSMS Data Import and EXport Wizard to transfer db tables between SQL Server instances (both v11). The identity column and primary key attributes are not transferred, which could cause errors ...Unanswered | 3 Replies | 254 Views | Created by sfmans - Wednesday, December 4, 2019 11:02 AM | Last reply by Samaneh Golnavaz - Wednesday, December 4, 2019 1:35 PM -
1 Votes
Where does SSDT Schema Compare Generate the script????????
Very nice SSDT tool... so I compare a couple databases, hit the "Generate Script" button... it says it completes.. and ???? where the heck is ...Unanswered | 4 Replies | 5369 Views | Created by c b - Wednesday, November 8, 2017 6:06 PM | Last reply by NarbehM - Tuesday, December 3, 2019 10:56 PM -
0 Votes
SSDT script generation bug - ExcludeObjectTypes for encrypted trigger
Hi, I think it's a bug in SSDT and quite old one. I've tried several versions of SSDT binaries but the problem persists. SQLPackage.exe doesn't exclude ...Unanswered | 2 Replies | 897 Views | Created by Brunas - Tuesday, November 21, 2017 10:01 AM | Last reply by Mahesh Dasari - Sunday, December 1, 2019 7:55 PM -
0 Votes
Error = [unixODBC][Microsoft][ODBC Driver 17 for SQL Server]Cannot generate SSPI context
Group: General Forum Members Points: 44 Visits: 40 Hi Excerpts , I have installed ...Unanswered | 2 Replies | 3435 Views | Created by satya RR - Thursday, October 4, 2018 12:18 PM | Last reply by Bramhesh Kumar Srivastava - Friday, November 29, 2019 5:32 AM -
1 Votes
Import using sqlPackage.exe fails with no permission error
The version of the SQL Server is 13.0.4001.0. Th version of the sqlPackage.exe is 13.0.3370.2. I tried to use sqlPackage.exe import a bacpac to this SQL Server, ...Answered | 3 Replies | 1466 Views | Created by Joey Wang_ - Wednesday, December 21, 2016 10:42 PM | Last reply by Joey Wang_ - Wednesday, November 27, 2019 7:28 PM -
0 Votes
The imported project "C:\Program Files (x86)\MSBuild\ExtensionPack\4.0\MSBuild.ExtensionPack.tasks" was not found
Hi! I'm using Visual Studio 2013 Ultimate Update 4 with SSDT v12.0.50512.0. I don't see a newer update for the SSDT. I get this message when I try to load a .SQLProj ...Unanswered | 5 Replies | 3418 Views | Created by Hassan Gulzar - Sunday, June 7, 2015 11:56 AM | Last reply by CodeNewbie - Wednesday, November 27, 2019 1:06 AM -
0 Votes
SSIS package Odata connection error
The connection type "ODATA" specified for connection manager is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection ...Answered | 3 Replies | 778 Views | Created by Ola Adegboyega - Wednesday, July 24, 2019 8:28 PM | Last reply by ModyDIOP - Tuesday, November 26, 2019 11:46 AM -
0 Votes
'No longer updating this content'
Hi, The main documentation page for SSDT says: We're no longer updating this content regularly. Check the Microsoft Product Lifecycle for information ...Unanswered | 3 Replies | 516 Views | Created by Nick Darvey - Tuesday, November 26, 2019 5:11 AM | Last reply by Vaibhav-Chaudhari - Tuesday, November 26, 2019 6:01 AM -
0 Votes
Export .bacpac File Using SQL Package
Hello, This is the first time I'm attempting to use sqlpackage.exe. I'm attempting to export a few tables to a .bacpac file to import into Azure ...Unanswered | 1 Replies | 472 Views | Created by anelliaf - Monday, November 25, 2019 5:29 PM | Last reply by Israel Haylamicheal - Monday, November 25, 2019 7:32 PM -
1 Votes
T4 Templating .sqlproj possible to build using MSBuild or TextTransform
Trying to process sqlproj T4 templates on the command line, happy to use TextTransform or MSBuild. Think (using TextTransform.exe) I need set -dp to get this directive to work ...Proposed | 3 Replies | 1937 Views | Created by OzzyGeoff - Saturday, June 21, 2014 4:40 PM | Last reply by Andrew Stanton - Sunday, November 24, 2019 4:31 PM - Items 1 to 20 of 4523 Next ›
No announcements