I hope one of you guys can help me? My Webhost set up a MSSQL Database for me? But how can i view it, access it and add stuff to it.
With php/mysql its very easy to update stuff add stuff delete stuff. You can use PHPMYADMIN but how does it work with MSSQL???????????

http://www.iisfaq.com/default.asp?View=A347&P=46

I'm a novice at SQL database and had little experience with SQL databases before...

MS SQL's Enterprise Manager allows me to create tables, edit data, backup, etc without typing or learning lots of syntax.

Yeah you pay for it..

I tried several front ends for Mysql and did not find one that offers all the power and features of the Enterprise manager.

Hopefully someday a tool with that level of functionality will exist..

Yeah, you can download the "SQL Server personal edition" from MS and It comes with the Enterprise Manager GUI as well, It works very well, although I've never run it across the internet, I know it should work.

http://www.microsoft.com/sql/evaluation/trial/2000/download.asp

After the trial runs out the Tools dont.

The Microsoft way is to use Microsoft Visual InterDev, which is a part of Microsoft Visual Studio. If you can find a copy at the right price it is a nice tool.