Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

closed as off-topic by Tog, Indrek, Dave, Kevin Panko, Bob Apr 30 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/… –  iSid 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 at 9:28
    
Glad to know it helped! –  iSid May 10 at 10:35

2 Answers 2

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

share|improve this answer

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

share|improve this answer
    
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

protected by Community Apr 29 at 10:27

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

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