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.googlegro ups.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:[vbcol=seagreen]
> Are you running
> SELECT DATABASEPROPERTYEX('AdventureWorks', 'STATUS');?
> "gurbao" <aud...@.gmail.com> wrote in messagenews:1168245796.230930.320800@.38g2000cwa.go oglegroups.com...
>
>
|||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.googlegro ups.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:
>
