Help with this CLR stored proc

  • Hi, please somebody help me with this store procedure. I am very confused. This is a CLR stored proc. I understand the basic is using a vb 'RODAssembly'. But what does exactly each line mean? I know this is rather basic, but didn't find help documents online.

    exec sys.sp_addextendedproperty @name = N'AutoDepolyed', @value = N'yes',@level0type = N'Schema',@level0name = N'dbo',

    @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

    exec sys.sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'RODAssembly.vb',@level0type = N'Schema',@level0name = N'dbo',

    @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

    exec sys.sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value =26,@level0type = N'Schema',@level0name = N'dbo', @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

  • mqy37 (12/14/2013)


    Hi, please somebody help me with this store procedure. I am very confused. This is a CLR stored proc. I understand the basic is using a vb 'RODAssembly'. But what does exactly each line mean? I know this is rather basic, but didn't find help documents online.

    exec sys.sp_addextendedproperty @name = N'AutoDepolyed', @value = N'yes',@level0type = N'Schema',@level0name = N'dbo',

    @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

    exec sys.sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'RODAssembly.vb',@level0type = N'Schema',@level0name = N'dbo',

    @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

    exec sys.sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value =26,@level0type = N'Schema',@level0name = N'dbo', @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'

    go

    All you have there is the last few lines of a deployment script for a CLR procedure, there's not a lot to be learned from them except that you have a CLR proc called dbo.SendMessageWithPriority and the source code file was called RODAssembly.vb.

    The three lines are just adding extended properties to an existing procedure (which the script will likely have created itself).

    Extended properties can be thought of as metadata often used to document objects in the database.

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

  • This is what I was looking for. So it compiles and executes the source code on the fly? I guessed the meaning, but nice to see it's correct. Thanks.

  • mqy37 (12/15/2013)


    ...So it compiles and executes the source code on the fly? I guessed the meaning, but nice to see it's correct. Thanks.

    That is not what I said and it is not what happens.

    The code you posted is just the last few commands from a bigger deployment script.

    You have not included the actual deployment, just a few "decorations".

    MM



    select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • Forum Etiquette: How to post Reporting Services problems
  • [/url]
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • [/url]
  • How to Post Performance Problems - by Gail Shaw
  • [/url]

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

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