Tuesday, February 14, 2012

Creating database, not showing in EM in SQL 7

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?
Actually, I also 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'?
Thanks,
TomYou need to refresh the EM database tree manually in order for databases
created outside the EM environment to show up.
--
Hope this helps.
Dan Guzman
SQL Server MVP
--
SQL FAQ links (courtesy Neil Pike):
http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
http://www.sqlserverfaq.com
http://www.mssqlserver.com/faq
--
"Thomas Scheiderich" <tfs@.deltanet.com> wrote in message
news:3FB84C76.2050608@.deltanet.com...
> 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?
> Actually, I also 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'?
> Thanks,
> Tom
>

No comments:

Post a Comment