I just stumbled over this SP_addextendedProperty, can anyone explain me what is this and why should we use it> I mean the benefit /leverage of using sp_addextendedproperty ?

I have gone throught this link it shows how to use by why is missing :) http://msdn.microsoft.com/en-us/library/ms180047.aspx

Thanks

http://sqlserverperformance.wordpress.com/2011/01/10/fun-with-extended-properties-in-sql-server-2008/

Nice article!

Hallo StSingh,

we are using sp_addextendedproperty to "flag" all our Sharepoint databases in a huge environment for passing by all maintenance issues concerning Microsoft Sharepoint!

Due to the fact that Sharepoint handles index fragmentation itself it is not supported by Microsoft to run your own index maintenance. We are using the great tool for index maintenance shppped by Ola Hallengren (http://ola.hallengren.com).

To exclude Sharepoint database we filter the "allowed" databases by querying the extended property set by a default routine when Sharepoint creates a new database by its own!