I would like to know where there is any front-end tool that i can use to access my MS SQL Server database on a remote machine. Basically i need to be able to create stored procedures, triggers, views etc. I was thinking of something similar to MySQL CC or MySQL Query Browser or MySQL Yog or MySQL Administrator - some tool which will enable me to manipulate my database? Any recommendation for a FREE product?
You can use Sql Server Management Studio Express. It's free and you can do most (if not all..) common tasks. Recommended
So Sql Server Management Studio Express and Tora! I'm gonna check them out, thanks. Ohh i do use MySQL but i want to get the extra features in MS SQL Server - stored procedures, triggers and views. Now i know i can get stored procedures in MySQL (v5.1?) but i've heard it's still in the alpha or beta stage.