Is there any free/open source alternative of SQL Prompt? SSMS 2008 R2 intellisense is good but I need it for code optimization. For example it should notify me when there is an unused variable declared.

closed as off-topic by Tog, Indrek, Dave, Kevin Panko, Bob Apr 30 '14 at 13:01

This question appears to be off-topic. The users who voted to close gave this specific reason:

  • "Questions seeking product, service, or learning material recommendations are off-topic because they become outdated quickly and attract opinion-based answers. Instead, describe your situation and the specific problem you're trying to solve. Share your research. Here are a few suggestions on how to properly ask this type of question." – Tog, Indrek, Dave, Kevin Panko, Bob
If this question can be reworded to fit the rules in the help center, please edit the question.

  • I'm not sure if this does what you want but Navicat works good for being free. – Justin Mar 28 '11 at 23:06
  • Thanks, but it's not free! navicat.com/en/products/navicat_sqlserver/… – IsmailS Mar 29 '11 at 7:38
  • It's closed, but it still help me and my company. We're a small team and have been using Sql Prompt for years. When we upgraded to SQL 2012 our old sql prompt stopped working. We missed it dearly, but I wasn't prepared to pay the price. This thread helped us find the right solution. Cheers – autonomatt May 10 '14 at 9:28
  • Glad to know it helped! – IsmailS May 10 '14 at 10:35

You can try out the free SSMS and VS add-in, ApexSQL Complete

ApexSQL Complete provides snippets and syntax checking and a lot of code auto-complete features (context based predicting keywords, users, objects, autocompleting aliases, the Insert procedure parameters automatically option , the Insert full INSERT statement option and so on)

For code refactoring you could use ApexSQL Refactor, also a free add-in

Disclaimer: I work for ApexSQL as a Support Engineer

  • ApexSQL doesn't seem to support Linked Servers that well. I have a linked server defined with different credentials stored and Apex would keep prompting for the credentials because it's using my current session credentials instead of the saved one defined in the linked server. This becomes problematic in environments where you have access to the linked server, but don't have knowledge of what the actual credentials are. SQL Prompt has no issues with figuring this out and automatically using the saved credentials for the linked server. – Lunyx Jun 30 '15 at 15:06
  • You are right ApexSQL doesn't support Linked Servers also it hangs my SSMS means it freezes my SSMS and takes time more than a min to load. But I love Refactor and Apex Search – user1413 Mar 17 '17 at 19:19
  • ApexSQL has poor performance, its not good option. – Mehdi Dehghani Apr 10 '17 at 8:17
  • Not as good as SQL Prompt. But it is configurable and FREE. – mahmoodvcs Mar 13 '18 at 11:29

SQL Complete is pretty good.There's a full edition (About $100) and a free express edition!

  • 1
    I use SQL Complete on a daily basis and am very happy with it. My co-workers use Redgate's SQLPrompt, and considering the cost, DBForge is definitely the better option. In the past few months they've added such features as linked-server completion, and basic support for synonyms. I have personally reported bugs and feature requests to them and have /always/ received a prompt reply, and in the case of serious bugs, a prompt fix. – BLSully Jul 10 '12 at 12:51

Not the answer you're looking for? Browse other questions tagged or ask your own question.