Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [sql-server-tools]

The tools included with or designed for SQL Server.

1
vote
3answers
54 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
792 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
437 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
717 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
468 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
313 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
86 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
825 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
632 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, ...