Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesOf course, none of mine have a status of 512, it is a combination of bits. I've got a lot of 1552's, which I think is 1024(readonly) + 512(offline) + 16(torn page detection). Then I also have a lot of 28s too. I am just not sure what to "reset" these numbers to. Is there a more comprehensive list anywhere about resetting the status? Thanks so much for helping me out with this. I couldn't find any info anywhere on this... "Daniel@tamc" wrote: > I used query analyzer to query MASTER database, sysdatabases table. > See this for more info: > http://msdn.microsoft.com/library/d... /> d_5xrn.asp > > Status field bits=512 indicates offline. > > "KZeeh" wrote: >
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread