Recovery Model code in SQL 2000

In SQL 2005, sys.databases has a column named recovery_model that stores a code for the type of recovery model used by the database. Where is the recovery_model column in the SQL 2000 master database?

Thanks,

Craig

Code Snippet

select name, Databasepropertyex(name, 'Recovery') recovery from master..sysdatabases

sql

Recovering SA Password or Adding sysadmin Login

Hi,
Recently some body played with our SQL Server and removed our Sys admin
group login and we dont have builtin\admin as login and no SA Password
can any body tell the way to come out with this situation to change the SA
Password or create our Group back with Sys admin priviledges.
also to confirm we are still in NT admin group for the server.
below article talk about similar case but as soon as i try to run sqlcmd
utility after taking server in single mode as per article ,it throws error
that you cant run sqlcmd since server in Single user mode.
Any help is appreciated..."sacgar" wrote:
> Hi,
> Recently some body played with our SQL Server and removed our Sys admin
> group login and we dont have builtin\admin as login and no SA Password
> can any body tell the way to come out with this situation to change the SA
> Password or create our Group back with Sys admin priviledges.
> also to confirm we are still in NT admin group for the server.
> below article talk about similar case but as soon as i try to run sqlcmd
> utility after taking server in single mode as per article ,it throws error
> that you cant run sqlcmd since server in Single user mode.
> Any help is appreciated...
Adding Link
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx

Recovering SA Password or Adding sysadmin Login

Hi,
Recently some body played with our SQL Server and removed our Sys admin
group login and we dont have builtin\admin as login and no SA Password
can any body tell the way to come out with this situation to change the SA
Password or create our Group back with Sys admin priviledges.
also to confirm we are still in NT admin group for the server.
below article talk about similar case but as soon as i try to run sqlcmd
utility after taking server in single mode as per article ,it throws error
that you cant run sqlcmd since server in Single user mode.
Any help is appreciated...
"sacgar" wrote:

> Hi,
> Recently some body played with our SQL Server and removed our Sys admin
> group login and we dont have builtin\admin as login and no SA Password
> can any body tell the way to come out with this situation to change the SA
> Password or create our Group back with Sys admin priviledges.
> also to confirm we are still in NT admin group for the server.
> below article talk about similar case but as soon as i try to run sqlcmd
> utility after taking server in single mode as per article ,it throws error
> that you cant run sqlcmd since server in Single user mode.
> Any help is appreciated...
Adding Link
http://blogs.msdn.com/raulga/archive/2007/07/12/disaster-recovery-what-to-do-when-the-sa-account-password-is-lost-in-sql-server-2005.aspx