Delete TempDB Database on SQL Server 2000 EE

I inherited a SQL Server 2000 Enterprise Edition database server that has
system databases that do appear in the SQL Server 2000 Enterprise Manager
GUI. How can get the system databases to appear in the SQL Server 2000
Enterprise Manager GUI? When I opened the Query Analyzer the system
databases appear.
Please help me resolve this issue.
Thanks,Right click on the name of the server and choose Edit SQL Server
Registration Properties. Check the box that says "Show system databases and
system objects"
Click OK
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,|||"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,|||"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,

Delete TempDB Database on SQL Server 2000 EE

I inherited a SQL Server 2000 Enterprise Edition database server that has
system databases that do appear in the SQL Server 2000 Enterprise Manager
GUI. How can get the system databases to appear in the SQL Server 2000
Enterprise Manager GUI? When I opened the Query Analyzer the system
databases appear.
Please help me resolve this issue.
Thanks,
Right click on the name of the server and choose Edit SQL Server
Registration Properties. Check the box that says "Show system databases and
system objects"
Click OK
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,
|||"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,
|||"Joe K." <JoeK@.discussions.microsoft.com> wrote in message
news:E9636172-06F5-4DAF-9EC0-992C661C48F1@.microsoft.com...
> I inherited a SQL Server 2000 Enterprise Edition database server that has
> system databases that do appear in the SQL Server 2000 Enterprise Manager
> GUI. How can get the system databases to appear in the SQL Server 2000
> Enterprise Manager GUI? When I opened the Query Analyzer the system
> databases appear.
> Please help me resolve this issue.
> Thanks,

Delete row from MS SQL Server 2000

Hi, I'm using SQL Server 2000 Personal Edition. I have created a table 'Student' which has 2 fields.

ID -- Varchar(10), Primary Key - contains ID of a student

NAME -- Varchar(50) -- contains names of student

ID NAME

0107200701 abcd

0107200702 cdgdh

0107200703 iyiylklk

.

.

I want to delete a complete row (all entries) from the "student" table using/specifing 'ID'. What will be the SQL query for that?

Hi

Try to use this (and please read help )

delete from Student where [ID] = '0107200701'

You should change the ID to your real ID

Regards,

Janos