Presents your 
SQL SERVER E-NEWSLETTER for October 24, 2002

<------------------------------------------->

REPORT WHAT DATABASE PROPERTIES HAVE BEEN SET

The function DATABASEPROPERTYEX is only available in SQL Server 2000.
The backward-compatible function DATABASEPROPERTY is still available 
but does not report the new functionality properties now available in SQL
Server 2000. The DATABASEPROPERTYEX function is an excellent function 
to report all the options on a database.

Following is a sample script that can be used to report all the
properties defined for DATABASEPROPERTYEX() in the pubs database:

SELECT 
CHAR(10),'collation',DATABASEPROPERTYEX( 'pubs' , 'collation' ),
CHAR(10),'IsAnsiNullDefault',DATABASEPROPERTYEX( 'pubs' , 'IsAnsiNullDefault' ),
CHAR(10),'IsAnsiNullsEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsAnsiNullsEnabled' ),
CHAR(10),'IsAnsiPaddingEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsAnsiPaddingEnabled' ),
CHAR(10),'IsAnsiWarningsEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsAnsiWarningsEnabled' ),
CHAR(10),'IsArithmeticAbortEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsArithmeticAbortEnabled' ),
CHAR(10),'IsAutoClose',DATABASEPROPERTYEX( 'pubs' , 'IsAutoClose' ),
CHAR(10),'IsAutoCreateStatistics',DATABASEPROPERTYEX( 'pubs' , 'IsAutoCreateStatistics' ),
CHAR(10),'IsAutoShrink',DATABASEPROPERTYEX( 'pubs' , 'IsAutoShrink' ),
CHAR(10),'IsAutoUpdateStatistics',DATABASEPROPERTYEX( 'pubs' , 'IsAutoUpdateStatistics' ),
CHAR(10),'IsCloseCursorsOnCommitEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsCloseCursorsOnCommitEnabled' ),
CHAR(10),'IsFulltextEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsFulltextEnabled' ),
CHAR(10),'IsInStandBy',DATABASEPROPERTYEX( 'pubs' , 'IsInStandBy' ),
CHAR(10),'IsLocalCursorsDefault',DATABASEPROPERTYEX( 'pubs' , 'IsLocalCursorsDefault' ),
CHAR(10),'IsMergePublished',DATABASEPROPERTYEX( 'pubs' , 'IsMergePublished' ),
CHAR(10),'IsNullConcat',DATABASEPROPERTYEX( 'pubs' , 'IsNullConcat' ),
CHAR(10),'IsNumericRoundAbortEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsNumericRoundAbortEnabled' ),
CHAR(10),'IsQuotedIdentifiersEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsQuotedIdentifiersEnabled' ),
CHAR(10),'IsRecursiveTriggersEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsRecursiveTriggersEnabled' ),
CHAR(10),'IsSubscribed',DATABASEPROPERTYEX( 'pubs' , 'IsSubscribed' ),
CHAR(10),'IsTornPageDetectionEnabled',DATABASEPROPERTYEX( 'pubs' , 'IsTornPageDetectionEnabled' ),
CHAR(10),'Recovery',DATABASEPROPERTYEX( 'pubs' , 'Recovery' ),
CHAR(10),'SQLSortOrder',DATABASEPROPERTYEX( 'pubs' , 'SQLSortOrder' ),
CHAR(10),'Status',DATABASEPROPERTYEX( 'pubs' , 'Status' ),
CHAR(10),'Updateability',DATABASEPROPERTYEX( 'pubs' , 'Updateability' ),
CHAR(10),'UserAccess',DATABASEPROPERTYEX( 'pubs' , 'UserAccess' ),
CHAR(10),'Version',DATABASEPROPERTYEX( 'pubs' , 'Version' )

----------------------------------------