phpMyAdmin similar program for MSSQL Server?

Is there any similar program(Like phpmyadmin) for MSSQLServer?

[NooK]

I am starting to develop on MS SQL Server and I wonder if anybody can suggest a freeware tool to manage the databases and be able to send queries and such, just like phphMyAdmin does for MySql?

PS: I am using microsoft's full SQL Server version and not the express one.

Best Regards

NooK

[Habtom]

I am starting to develop on MS SQL Server and I wonder if anybody can suggest a freeware tool to manage the databases and be able to send queries and such, just like phphMyAdmin does for MySql?

If your question is, about getting an interface over the web for MS SQL as phpmyadmin does for mysql, Cibersql Web Admin could be a solution for you. I never tried it myself but Microsoft [microsoft.com] has it on their list.

Cibersql Web Admin is a web-based application for managing and administering Microsoft SQL Server and MSDE databases. Cibersql Web Admin allows users to access their databases from around the world, 24X7 via a web browser

Habtom

[NooK]

Thank you but I forgot to say, I am using SQL Server 2005.

Indeed this is what I am looking for (Either that or a windows software will do too).

Can you recommend any for SQL Server 2005?`

Best Regards

NooK

[Habtom]

Can you recommend any for SQL Server 2005?

I merely knew they existed, and can't really say I recommend one from the other.

On the same link I provided you before, if you scroll down you will see another product "My little admin", it claims it does it for SQL Ms SQL Server 2005. You might give it a try.

My guess is there are more products, so before you begin using one, you might need to compare the products. And I wouldn't expect them to be Open Source or free for that matter.

Habtom

[SteveLetwin]

Doesn't MS SQL server come with an windows app like that? At least one of the versions from a couple years ago did. You could do all the administrative tasks, but also interactively enter queries and there was even a graphical sort of query builder.

Or is the problem you don't own the software package but just have access and privileges to use the database?

There's Microsoft SQL Server Management Studio Express [microsoft.com] which is a free to download tool that may work for you.

SSMSE can also manage instances of the SQL Server Database Engine created by any edition of SQL Server 2005.

Note: SSMSE cannot manage SQL Server Analysis Services, Integration Services, Notification Services, Reporting Services, SQL Server Agent, or SQL Server 2005 Mobile Edition.

I can't tell by that if it means it can manage non-express SQL Server 2005 or not.