Barkingdog
SSCoach
Points: 18670
More actions
June 5, 2003 at 9:38 am
#65600
How can I tell if a table was created using ANSI_PADDING set to on or off?
How can I tell the current status of ANSI_NULLS?
TIA,
Bill
Allen Cui-55137
SSC Guru
Points: 51650
June 5, 2003 at 9:56 am
#459996
OBJECTPROPERTY ( object_id(tablename), 'IsAnsiNullsOn')
DATABASEPROPERTYEX( youedatabase , 'IsAnsiPaddingEnabled' )
DBCC USEROPTIONS
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply