MS SQL Database Manager

This is going to be a very newbie question. :)

I am just wondering if there is anything that provides a GUI inferface to manage MS SQL? (Like PHPAdmin for MySQL..)

You can certainly use the SQL Server Enterprise Manager. You can get that with any version of SQL Server, including the Developer's Edition, which sells for about US$40.00. There are also a number of Web based admin tools as well, though I have not used them. Finally, many tasks can be performed throught he appropriate version of Visual Studio .NET.|||Enterprise Manager is enough usually. I can advice MS SQL Manager as an alternative: http://www.sqlmanager.net/products/mssql/manager

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?
Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techinf...sKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?
|||Thank you.

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techinfo/planning/SQLResKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?|||Thank you.

MS SQL 2000 Developer Edition.

Hi.
I am looking to install MS SQL 2000 on my laptop. The
purpose of which is to develop GUI and Web applications.
These applications will be installed onto our main servers
which are running MS SQL 7 and/or 2000 (V7s are scheduled
for upgrading and the new development will not be complete
before this upgrade so no need to look at V7).
Am I right in thinking the developer edition of MSSQL2K is
the appropriate product? Does this come with the
complete "manager" program and all the online books like
the full edition?
Are there any other differences between the developer
and "standard" (or whatever this is called).
Any comments, web pages, etc. would be greatly appreciated.
Regards,
Richard Quadling.
P.S. Is there a better place than in the newsgroups to ask
such questions?Richard,
Yes, that would be the correct product for development work. Developer
Edition is the same as Enterprise Edition, except it is not licensed for
production use. You may want to test your application on a standard edition
server to ensure it will work in production first.
Choosing an Edition of SQL Server 2000
http://www.microsoft.com/sql/techin...esKChooseEd.asp
How to Buy
http://www.microsoft.com/sql/howtobuy/default.asp
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
"Richard Quadling" <richard.quadling@.carval.co.uk> wrote in message
news:4c6801c42c30$10f46140$a101280a@.phx.gbl...
> Hi.
> I am looking to install MS SQL 2000 on my laptop. The
> purpose of which is to develop GUI and Web applications.
> These applications will be installed onto our main servers
> which are running MS SQL 7 and/or 2000 (V7s are scheduled
> for upgrading and the new development will not be complete
> before this upgrade so no need to look at V7).
> Am I right in thinking the developer edition of MSSQL2K is
> the appropriate product? Does this come with the
> complete "manager" program and all the online books like
> the full edition?
> Are there any other differences between the developer
> and "standard" (or whatever this is called).
> Any comments, web pages, etc. would be greatly appreciated.
> Regards,
> Richard Quadling.
> P.S. Is there a better place than in the newsgroups to ask
> such questions?|||Thank you.

MS SQL 2000 Desltop

I have installed MS SQL 2000 Desktop Engine. How can I create database,
tables and query through command. There is no GUI available.Raj wrote:
> I have installed MS SQL 2000 Desktop Engine. How can I create database,
> tables and query through command. There is no GUI available.
>
>
You can use osql.exe tool or you can use DbaMgr2k
http://www.asql.biz/en/DbaMgr.aspx
regards
SW|||Raj wrote:
> I have installed MS SQL 2000 Desktop Engine. How can I create database,
> tables and query through command. There is no GUI available.
>
>
Use OSQL, or download the free SQL Server 2005 Management Studio
Express, which I believe will connect to MSDE.
http://msdn.microsoft.com/vstudio/express/sql/
Tracy McKibben
MCDBA
http://www.realsqlguy.com

MS SQL 2000 Desltop

I have installed MS SQL 2000 Desktop Engine. How can I create database,
tables and query through command. There is no GUI available.Raj wrote:
> I have installed MS SQL 2000 Desktop Engine. How can I create database,
> tables and query through command. There is no GUI available.
>
>
You can use osql.exe tool or you can use DbaMgr2k
http://www.asql.biz/en/DbaMgr.aspx
regards
SW|||Raj wrote:
> I have installed MS SQL 2000 Desktop Engine. How can I create database,
> tables and query through command. There is no GUI available.
>
>
Use OSQL, or download the free SQL Server 2005 Management Studio
Express, which I believe will connect to MSDE.
http://msdn.microsoft.com/vstudio/express/sql/
Tracy McKibben
MCDBA
http://www.realsqlguy.com