No announcements
-
0 VotesFuncky SSMS Tabs
We are using SQL Server 2016 and SSMS v. 18.4 If I open multiple tabs to view/edit a stored procedure(s) and click back on a previous tab stored procedure the display stays on the ...
-
0 Votes
SSMS throws an exception when you a drag a table object on new query window
SSMS throws an exception when you a drag a table object on new query window. SSMS Version: 18 on windows 10. SQL Server Management Studio ...Unanswered | 1 Replies | 63 Views | Created by MLTC - Friday, December 27, 2019 4:59 PM | Last reply by Tom Phillips - Friday, December 27, 2019 5:28 PM -
0 Votes
Publish - Removes permissions and then adds them all back
When I generate a publish script it contains DDL to remove all permissions and then adds them all back at the end. None of the permissions have changed and I am not sure why I would ...Unanswered | 1 Replies | 313 Views | Created by Bob M (SQL Guy) - Friday, December 20, 2019 8:45 PM | Last reply by Olaf Helper - Friday, December 27, 2019 12:27 PM -
0 Votes
SQL visual studio project output file .publish.sql
The SQL visual studio project generates an output file "*.publish.sql" in bin folder. For every publish , there will be a .publish.sql files incremental added. My question is do i need to ... -
2 Votes
Importing a .bacpac from SQL Azure into a local SQL Server 2016 server gives errors
System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ---> System.AggregateException: One or more errors occurred. ...Unanswered | 5 Replies | 966 Views | Created by Lyle6 - Tuesday, July 18, 2017 8:11 PM | Last reply by Max Gavronskiy - Thursday, December 19, 2019 9:32 PM -
0 Votes
SQL SCHEMA COMPARE C#
Hello, i have a program in c# for comparing DACPAC with database in sql server. I want to know how i can exclude from comparison the type of columns. I don't want ... -
0 Votes
Letterproblem SSRS
Hi, I am trying to move my SSRS-Project from a Windows Server 2008 with Visual Studio 2013 to a Windows Server 2016 with Visual Studio 2017 and SSDT version ... -
0 Votes
SSIS Foreach sub folder loop
In a nutshell the requirement is that a Year Folder will contain a month folder and the month folder will contain several excel file...I have tried to upload all the files from the sub-folders but ...Answered | 1 Replies | 296 Views | Created by Durbslaw - Tuesday, December 17, 2019 3:26 PM | Last reply by Durbslaw - Wednesday, December 18, 2019 8:36 AM -
0 Votes
Can't establish any connection to SQL Server from Azure Data Studio (Linux)
I was pretty happy with the SQL Operations Studio on my Windows VM. So i was really stoked to see it's successor Azure Data Studio to be released for Linux Plattform. But ... -
0 Votes
DACPAC Unpack and repack
I want to customize my DACPAC file please suggest how we can do that as with current DACPAC it generated lot of unwanted code with take lot of time to upgrade ...Discussion | 1 Replies | 638 Views | Created by Piyush Mani - Wednesday, December 11, 2019 3:03 PM | Last reply by Cedric.G - Thursday, December 12, 2019 3:19 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 | 5 Replies | 2379 Views | Created by OzzyGeoff - Saturday, June 21, 2014 4:40 PM | Last reply by Andrey Belyakov - Thursday, December 12, 2019 10:15 AM -
0 Votes
Error pulblishing Temporal table using non default file group in VS 2017 SSDT
I use a non-default file group called [secondary]. I'm using VS 2017 SSDT latest version. I'm trying to alter a table to make it a temporal. Whne I try pulish it I get an ... -
6 Votes
Feature Request - making SSDT more extensible
Hello, We use SSDT and find it to be indispensable when deploying databases to our customers. We often need to alter this process and it would be great to have these ...Discussion | 15 Replies | 3005 Views | Created by Tadeusz - Friday, September 20, 2013 9:36 AM | Last reply by Tadeusz - Wednesday, December 11, 2019 12:20 PM -
0 Votes
CREATE CERTIFICATE .. FROM BINARY
Visual Studio 2013 - Database Project. Im trying to create a certificate with the following syntax. CREATE CERTIFICATE [MyCert] FROM BINARY = ...Proposed | 2 Replies | 2187 Views | Created by Danny Quinn - Friday, May 9, 2014 11:13 AM | Last reply by Solomon Rutzky - Tuesday, December 10, 2019 3:00 PM -
3 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 | 1163 Views | Created by EricDAllen - Thursday, October 17, 2019 12:21 PM | Last reply by caseyboyle1986 - Tuesday, December 10, 2019 5:19 AM -
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 | 550 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 | 605 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 | 895 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 | 1524 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 | 501 Views | Created by John Piraino - Thursday, December 5, 2019 10:01 PM | Last reply by Vaibhav-Chaudhari - Friday, December 6, 2019 4:57 AM - Items 1 to 20 of 4532 Next ›
No announcements
