Questions tagged [sql-server-tools]

The tools included with or designed for SQL Server.

Filter by
Sorted by
Tagged with
0
votes
1answer
61 views

Is SQL Server Data Tools a paid product of Microsoft or a Free Product?

I don't find an evidence in Microsoft Pages regarding SQL Server Data Tools Licensing and Price details. https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-server-...
1
vote
3answers
57 views

Long/complex INSERT and UPDATE query parser or visual editor/query builder [closed]

I have long INSERT queries that insert values to table with over 50 columns. Is there any tool to parse this long query to key-value representation? like: INSERT INTO sometable(col1, col2, col3) ...
0
votes
1answer
851 views

Problem installing mssql-tools “ODBC Driver 17”

Whenever I try to apt-get install mssql-tools, I get, Preconfiguring packages ... (Reading database ... 302749 files and directories currently installed.) Preparing to unpack .../msodbcsql17_17.0.1.1-...
8
votes
1answer
462 views

Does SQL Server 2016 still contain sqlmaint.exe?

According to the documentation (Deprecated Database Engine Features in SQL Server 2016), sqlmaint.exe should still be available (emphasis mine): This topic describes the deprecated SQL Server ...
0
votes
1answer
851 views

Complicated SSRS layout - is that possible?

I have been ordered to do a report with a pretty sophisticated table layout. Okay, it's not that sophisticated, but we all know how SSRS is with those things. I am pretty certain that layout cannot be ...
1
vote
3answers
495 views

Drop All Columns in a Table that are not Keys

This may seem like an odd request but let me explain, there may be a tool that I haven't found that will do what I need. I couldn't make SSMS do what I needed Goal: To deliver a Database Diagram that ...
0
votes
1answer
329 views

HeidiSQL solution for SQL Server error 18488?

I'm connecting to a remote database using HeidiSQL client but looks like the administrator has activated the enforce password change policy (Error 18488). Is there a workaround to solve this with ...
3
votes
2answers
87 views

Meaning of “The database X needs to be upgraded” in ClearTrace

I'm trying out ClearTrace from http://www.scalesql.com/cleartrace/download.html , but it isn't very user friendly from my first impression. I have a database in SQL Server 2008 that I'm adding in the ...
0
votes
1answer
828 views

Role-Schema Permission issue (Management studio)

When designing a new database I organized the table under different schemas. I've also created a new role that should have select/insert/update/delete rights on one schema and only select on another ...
0
votes
2answers
1k views

SQL Server 2008: Diff table data on different servers with exact schema

I'm trying to find a good open source tool that simply compares data in a database on one server to a table (of the same schema) on another server. Then I want to generate INSERT statements for the ...
8
votes
2answers
641 views

Alternatives for SSMS solutions & projects?

According to the official SQL Server Documentation, the use of "Solutions, Projects, and Items" is deprecated. A conspicuous (though somewhat cryptic) warning banner at the top of the MSDN page ...
4
votes
1answer
4k views

Management Studio 2012 Backward Compatibility

Two quick questions for anybody that's tried this: Will Management Studio 2012 install and run side-by-side with, say, Management Studio 2008? I vaguely recall not being able to do this with 2008 and ...
3
votes
2answers
1k views

Editing built-in templates in Management Studio

I'm running SQL Server Management Studio 2008 (10.0.5500.0) and was attempting to edit the built-in template "Create T-SQL Trigger (New Menu)". I open the Template Explorer, right-click the template, ...