I need to query DB installation on SQL Server 2005 to return all the defaults with their values. I can retrieve the names of all the defaults from following query:
SELECT name FROM sys.objects WHERE OBJECTPROPERTY(object_id, N'IsDefault') = 1
However, I will like to get the values of the defaults as well. I have searched the books online but couldnt find any suitable example.
Can you please point me in the right direction?