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, BobApr 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

2 Answers

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

All the money in the world movie in atlanta. 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

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

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