Creating database, not showing in EM

[tfstom]

I am running Sql 7 on windows NT.

I am trying to create a database by opening the Query Analyser and entering the following:

create database ScriptTest
on
( Name = 'ScriptTest_Data',
Filename = 'c:\mssql7\data\ScriptTest_Data.mdf',
Size = 5MB,
Maxsize = 25MB,
FileGrowth = 5MB )
Log on
( Name = 'ScriptTest_log',
Filename = 'c:\mssql7\data\ScriptTest_Log.ldf',
Size = 2MB,
Maxsize = 12MB,
FileGrowth = 20% )

The 2 data files are created fine. But it is not showing in the Enterprise Manager.

Now, when I opened the Query Analyser, the DB is showing Master. Is this correct?

Thanks,

Tom.

 

[tfstom]

Actually, I just found that if I create a database in the Query Analyser - it shows in the Query analysers drop down box, but not in EM.

If I create it in EM, it shows in EM but not in Query Analyser.

Why???????

 

[nigelrivett]

The lest of databases in e-m is not updated automatically. Right click on databases and click refresh.

In query analyser it should turn up.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[tfstom]

How stupid !!!!!

Brain Fade.

You were right, but my problem was that I had 2 servers in my EM and didn't notice that I was pointing at one in EM and one in Query Analyser.

They were there, just in the other server.

Sorry,

Tom