Model Database Status is 1073741824

After upgrade SQL Server 7 to SQL Server 2000, the model database status bec
omes 1073741824. What does it mean? I can create a new database in this stat
us. 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 cre
ate new database. However,the model database status is 1073741824 (cleanly s
hutdown) (before update SQL Server, the status is 0). It is a problem? Can I
say the upgrade is success
ful? Can I change the status and how to do?
"Dan Guzman" wrote:

> 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 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...
> becomes 1073741824. What does it mean? I can create a new database in this
> status. How do I change it?
>
>|||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?[vbcol=seagreen]
> "Dan Guzman" wrote:
>
status[vbcol=seagreen]
status[vbcol=seagreen]
this[vbcol=seagreen]sql