webooth
SSCommitted
Points: 1550
More actions
July 9, 2002 at 9:01 am
#173206
Does anyone know what the value 4194316 in the status field of the sysdatabases table in a sql server 7.0 database means?
Andy Warren
SSC Guru
Points: 119902
July 9, 2002 at 9:16 am
#432253
You have to figure it out by adding up which bits are set:
4 = select into/bulkcopy; set with sp_dboption.
8 = trunc. log on chkpt; set with sp_dboption.
4194304 = autoshrink.
Andy
http://www.sqlservercentral.com/columnists/awarren/
AndySQLAndy - My Blog!Connect with me on LinkedInFollow me on Twitter
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply