Model Database Status is 1073741824

After upgrade SQL Server 7 to SQL Server 2000, the model database status becomes 1073741824. What does it mean? I can create a new database in this status. How do I change it?
Thanks
Walter> After upgrade SQL Server 7 to SQL Server 2000, the model database status
becomes 1073741824. What does it mean?
From the SQL Server 2000 Books Online
<herf="tsqlref.chm::/ts_sys-d_5xrn.htm">, 1073741824 = cleanly shutdown.
> I can create a new database in this status. How do I change it?
I don't understand this part of your question. Please elaborate.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:E1EE009E-34CB-4681-935C-1B30B6DF1B52@.microsoft.com...
> After upgrade SQL Server 7 to SQL Server 2000, the model database status
becomes 1073741824. What does it mean? I can create a new database in this
status. How do I change it?
> Thanks
> Walter|||After upgrade SQL Server from 7 to 2000, the server looks fine and I can create new database. However,the model database status is 1073741824 (cleanly shutdown) (before update SQL Server, the status is 0). It is a problem? Can I say the upgrade is successful? Can I change the status and how to do?
"Dan Guzman" wrote:
> > After upgrade SQL Server 7 to SQL Server 2000, the model database status
> becomes 1073741824. What does it mean?
> From the SQL Server 2000 Books Online
> <herf="tsqlref.chm::/ts_sys-d_5xrn.htm">, 1073741824 = cleanly shutdown.
> > I can create a new database in this status. How do I change it?
> I don't understand this part of your question. Please elaborate.
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Walter" <Walter@.discussions.microsoft.com> wrote in message
> news:E1EE009E-34CB-4681-935C-1B30B6DF1B52@.microsoft.com...
> > After upgrade SQL Server 7 to SQL Server 2000, the model database status
> becomes 1073741824. What does it mean? I can create a new database in this
> status. How do I change it?
> >
> > Thanks
> > Walter
>
>|||Yes, this is a normal status for the model database. My test server, a new
SQL 2000 install, has status 1073741824.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Walter" <Walter@.discussions.microsoft.com> wrote in message
news:AEE3D7B1-3FD3-4BC8-A656-25BC7F1E1382@.microsoft.com...
> After upgrade SQL Server from 7 to 2000, the server looks fine and I can
create new database. However,the model database status is 1073741824
(cleanly shutdown) (before update SQL Server, the status is 0). It is a
problem? Can I say the upgrade is successful? Can I change the status and
how to do?
> "Dan Guzman" wrote:
> > > After upgrade SQL Server 7 to SQL Server 2000, the model database
status
> > becomes 1073741824. What does it mean?
> >
> > From the SQL Server 2000 Books Online
> > <herf="tsqlref.chm::/ts_sys-d_5xrn.htm">, 1073741824 = cleanly shutdown.
> >
> > > I can create a new database in this status. How do I change it?
> >
> > I don't understand this part of your question. Please elaborate.
> >
> > --
> > Hope this helps.
> >
> > Dan Guzman
> > SQL Server MVP
> >
> > "Walter" <Walter@.discussions.microsoft.com> wrote in message
> > news:E1EE009E-34CB-4681-935C-1B30B6DF1B52@.microsoft.com...
> > > After upgrade SQL Server 7 to SQL Server 2000, the model database
status
> > becomes 1073741824. What does it mean? I can create a new database in
this
> > status. How do I change it?
> > >
> > > Thanks
> > > Walter
> >
> >
> >