<p>I was wondering if there are any alternatives to Microsoft's SQL Server Management Studio?</p>

<p>Not there's anything wrong with SSMS, but sometimes it just seem too big an application where all I want todo is browse/edit tables and run queries.</p>

[{'answer_id': 5184, 'author': 'brendan', 'author_id': 225, 'author_profile': 'https://Stackoverflow.com/users/225', 'pm_score': 4, 'selected': False, 'text': '<p><a href="http://toadworld.com/" rel="noreferrer">TOAD for MS SQL</a> looks pretty good.  I\'ve never used it personally but I have used Quest\'s other products and they\'re solid.</p>\n'}, {'answer_id': 5201, 'author': 'Paul G', 'author_id': 162, 'author_profile': 'https://Stackoverflow.com/users/162', 'pm_score': 2, 'selected': False, 'text': '<p>There is an <a href="http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&amp;displaylang=en" rel="nofollow noreferrer">express version on SSMS</a> that has considerably fewer features but still has the basics.</p>\n'}, {'answer_id': 5270, 'author': 'Evan', 'author_id': 667, 'author_profile': 'https://Stackoverflow.com/users/667', 'pm_score': 7, 'selected': True, 'text': '<p>I\'ve started using <a href="http://www.linqpad.net/" rel="noreferrer" title="Linq Pad">LinqPad</a>. In addition to being more lightweight than SSMS, you can also practice writing LINQ queries- way more fun than boring old TSQL!</p>\n'}, {'answer_id': 5491, 'author': 'Daniel O', 'author_id': 697, 'author_profile': 'https://Stackoverflow.com/users/697', 'pm_score': 3, 'selected': False, 'text': "<p>If you are already spending time in Visual Studio, then you can always use the <strong>Server Explorer</strong> to connect to any .Net compliant database server.</p>\n\n<p>Provided you're using Professional or greater, you can create and edit tables and databases, run queries, etc.</p>\n"}, {'answer_id': 364474, 'author': 'dkretz', 'author_id': 31641, 'author_profile': 'https://Stackoverflow.com/users/31641', 'pm_score': 1, 'selected': False, 'text': '<p>You can still install and use Query Analyzer from previous SQL Server versions.</p>\n'}, {'answer_id': 364481, 'author': 'aef123', 'author_id': 41117, 'author_profile': 'https://Stackoverflow.com/users/41117', 'pm_score': 2, 'selected': False, 'text': '<p>Oracle has a free program called SQL Developer which will work with Microsoft SQL Server as well as Oracle &amp; MySQL.  When accessing SQL Server, however, Oracle SQL Developer is only intended to enable an easy migration to Oracle, so your SQL Server database is essentially read-only.</p>\n'}, {'answer_id': 364546, 'author': 'Thuglife', 'author_id': 41612, 'author_profile': 'https://Stackoverflow.com/users/41612', 'pm_score': 3, 'selected': False, 'text': '<p><a href="http://www.microsoft.com/windowsserver2003/technologies/management/powershell/download.mspx" rel="noreferrer">powershell</a> + <a href="http://msdn.microsoft.com/en-us/library/ms162773.aspx" rel="noreferrer">sqlcmd</a> :)</p>\n'}, {'answer_id': 2340789, 'author': 'Piotr Owsiak', 'author_id': 80421, 'author_profile': 'https://Stackoverflow.com/users/80421', 'pm_score': 4, 'selected': False, 'text': '<p>Seems that no one mentioned <a href="http://www.albahari.com/queryexpress.aspx" rel="noreferrer">Query Express</a> (<a href="http://www.albahari.com/queryexpress.aspx" rel="noreferrer">http://www.albahari.com/queryexpress.aspx</a>) and a fork <a href="http://sourceforge.net/projects/queryexplus/" rel="noreferrer">Query ExPlus</a> (also link at the bottom of <a href="http://www.albahari.com/queryexpress.aspx" rel="noreferrer">http://www.albahari.com/queryexpress.aspx</a>)</p>\n\n<p>BTW. First URL is the home page of Joseph Albahari who is the author of LINQPad (check out this killer tool)</p>\n'}, {'answer_id': 5126242, 'author': 'Govind Malviya', 'author_id': 355063, 'author_profile': 'https://Stackoverflow.com/users/355063', 'pm_score': 4, 'selected': False, 'text': '<p><a href="http://fishcodelib.com/Database.htm">Database .NET</a></p>\n'}, {'answer_id': 7664589, 'author': 'sumek', 'author_id': 11439, 'author_profile': 'https://Stackoverflow.com/users/11439', 'pm_score': 2, 'selected': False, 'text': '<p>vim + <a href="http://www.vim.org/scripts/script.php?script_id=356" rel="nofollow">dbext</a> :)</p>\n'}, {'answer_id': 9596344, 'author': 'user_v', 'author_id': 129206, 'author_profile': 'https://Stackoverflow.com/users/129206', 'pm_score': 4, 'selected': False, 'text': '<p>I have been using <a href="http://www.atlantis-interactive.co.uk/products/sqleverywhere/default.aspx" rel="noreferrer">Atlantis SQL Enywhere</a>, a free software, for almost 6 months and has been working really well. Works with SQL 2005 and SQL 2008 versions. I am really impressed with its features and keyboard shortcuts are similar to VS, so makes the transition really smooth to a new editor.</p>\n\n<p>Some of the features that are worth mentioning:</p>\n\n<ul>\n<li>Intellisense that actually works when using multiple tables and joins with aliases  </li>\n<li>Suggestion of joins when using multiple tables (reduces time on typing, really neat)  </li>\n<li>Rich formatting of sql code, AutoIndent using Ctrl K, Ctrl D.  </li>\n<li>Better representation of SQL plans  </li>\n<li>Highlights variables declarations while they are used.  </li>\n<li>Table definition on mouse hover.  </li>\n</ul>\n\n<p>All these features have saved me lot of time.</p>\n'}, {'answer_id': 10818967, 'author': 'pyccki', 'author_id': 103303, 'author_profile': 'https://Stackoverflow.com/users/103303', 'pm_score': 1, 'selected': False, 'text': '<p>How about Embarcadero <a href="http://www.embarcadero.com/products/rapid-sql-xe3" rel="nofollow">Rapid SQL</a> Really good but kind of expensive.</p>\n'}]
['https://Stackoverflow.com/questions/5170', 'https://Stackoverflow.com', 'https://Stackoverflow.com/users/383/']