Are there any great tools as an alternative TOAD to be used for SQL Server?
The tool can be commerical or open source.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
Say TOAD for SQL Server? I dont't have experience with it, probably you have your reason asking for a replacement tool.
SQL Server Management Studio that comes with SQL Server?
If you need to run on non-Windows, then look at SQuireeL
Personally, I am a fervent user of Navicat. The Premium version allows connecting to multiple database servers. Am also very content with their support, already had several cases resolved, although sometimes it doesn't get in until the next version. (I am not affiliated with them.)
Although the Navicat UI is more polished, the feature set and extensible nature of Apex SQLEdit blows the doors off any other QA replacement I've found. Between replacement tokens, context sensitive custom scripts (i.e., right click a table and you're presented with a list of your own CUSTOM scripts specific to TABLES with token replacement), quick info, data mining right out of the result grid, sorting and filtering in grid, etc., etc.
At that point, you may as well keep SSMS, add RedGate SQL prompt (nice) and/or SSMS Tools (free/donate) to get only a pinch of what Apex offers.
Note, I have, in no way, explored Navicat features completely, just blown away by the apparent LACK of features during my first experience with the tool, especially where the rubber meets the road, query building and result grid features.