SELECT [Whims_and_Fancies] from [my_SQL_Server_Knowledge];
I would like to refer this Interesting thread that talks about advantages you can take with Profile when you have a need of refactoring the database objects between old & new versions, useful tips on the post too.
About satya
SQL Server MVP.
SQL Master, Speaker & SQL Server helper.
16+ years of IT experience in which as a Sr. DBA and Technical Design Lead in sectors of Banking, Stock markets & Investment Banking, Manufacturing & consulting.
Out of professional activities :
Moderator - SQL Server Performance forums & MSDN forums in addition to my homepage above.
Active member of most of the SQL Server community forums.