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);