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