Questions tagged [sql-server-tools]

The tools included with or designed for SQL Server.

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

Search for an expression in Redgate's SQL Search

I can find word and terms inside stored proc and database, but I can't specifically search for an expression like WHERE name LIKE '%005%'. Is it possible to do that with the Redgate SQL Search plugin ...
Sayaman's user avatar
  • 211
1 vote
2 answers
4k 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://learn.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt?view=sql-...
Sathiya Kumar V M's user avatar
1 vote
3 answers
262 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) ...
Konrad's user avatar
  • 209
0 votes
1 answer
3k 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-...
Evan Carroll's user avatar
  • 63.2k
8 votes
1 answer
825 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 ...
Heinzi's user avatar
  • 3,145
0 votes
1 answer
3k 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 ...
Mashchax's user avatar
  • 155
1 vote
3 answers
1k 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 ...
Tim's user avatar
  • 155
0 votes
1 answer
634 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 ...
raziel's user avatar
  • 1
3 votes
2 answers
130 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 ...
kristianp's user avatar
  • 203
0 votes
1 answer
882 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 ...
Benoittr's user avatar
  • 103
0 votes
2 answers
2k 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 ...
JustBeingHelpful's user avatar
8 votes
2 answers
803 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 ...
kmote's user avatar
  • 607
4 votes
1 answer
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 ...
db2's user avatar
  • 9,658
3 votes
2 answers
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, ...
db2's user avatar
  • 9,658