Post reply

microsoft_database_tools_deploystamp

  • August 5, 2010 at 3:53 pm

    #236303

    Hi everyone!!

    I am working on trying to understand some continuous integration database builds stuff using DBPro. We are trying to work out the versioning and I saw some code that looks like this:

    USE [$(DatabaseName)]

    IF ((SELECT COUNT(*)

    FROM

    ::fn_listextendedproperty( 'microsoft_database_tools_deploystamp', null, null, null, null, null, null ))

    > 0)

    BEGIN

    EXEC [dbo].sp_dropextendedproperty 'microsoft_database_tools_deploystamp'

    END

    EXEC [dbo].sp_addextendedproperty 'microsoft_database_tools_deploystamp', N'<some long dang number>'

    GO

    I see this name/value pair in the extented properties section of the database properties.

    Can you tell me what/where/how that number is generated and what it means???

    thank you!! :hehe:

    Thank you!!,

    Angelindiego

  • August 5, 2010 at 9:33 pm

    #1203238

    Here is the official documentation of that function.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • August 6, 2010 at 8:31 am

    #1203562

    Thank you!! Have a great weekend!! 😀

    Thank you!!,

    Angelindiego

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply