Friday, February 17, 2012

Database with status 65544

SQL Server 2005 SP1
I have a few databases with status 65544.
Looking into the status column I am not sure what bits are set on and
off to get this status.
Can anyone please explain this to me?
Regards,Are you running
SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS');?
"gurbao" <audunj@.gmail.com> wrote in message
news:1168245796.230930.320800@.38g2000cwa.googlegroups.com...
> SQL Server 2005 SP1
> I have a few databases with status 65544.
> Looking into the status column I am not sure what bits are set on and
> off to get this status.
> Can anyone please explain this to me?
> Regards,
>|||No, I run:
select name, status from sysdatabases;
SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS'); returns
'ONLINE'
Just trying to figure out which status bits are set.
regards,
On Jan 8, 9:55 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
> Are you running
> SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS');?
> "gurbao" <aud...@.gmail.com> wrote in messagenews:1168245796.230930.320800@.38g2000cwa.googlegroups.com...
>
> > SQL Server 2005 SP1
> > I have a few databases with status 65544.
> > Looking into the status column I am not sure what bits are set on and
> > off to get this status.
> > Can anyone please explain this to me?
> > Regards,- Hide quoted text -- Show quoted text -|||I have no idea , but I used SQL Server 2005 system views instead.
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/a616fce9-b4c1-49da-87a7-9d6f74911d8f.htm
"gurbao" <audunj@.gmail.com> wrote in message
news:1168249703.000190.135630@.11g2000cwr.googlegroups.com...
> No, I run:
> select name, status from sysdatabases;
> SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS'); returns
> 'ONLINE'
> Just trying to figure out which status bits are set.
> regards,
>
> On Jan 8, 9:55 am, "Uri Dimant" <u...@.iscar.co.il> wrote:
>> Are you running
>> SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS');?
>> "gurbao" <aud...@.gmail.com> wrote in
>> messagenews:1168245796.230930.320800@.38g2000cwa.googlegroups.com...
>>
>> > SQL Server 2005 SP1
>> > I have a few databases with status 65544.
>> > Looking into the status column I am not sure what bits are set on and
>> > off to get this status.
>> > Can anyone please explain this to me?
>> > Regards,- Hide quoted text -- Show quoted text -
>