Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
Theresa37
Starting Member
1 Post |
Posted - 2013-12-14 : 19:13:34
|
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'goexec sys.sp_addextendedproperty @name = N'SqlAssemblyFile', @value = N'RODAssembly.vb',@level0type = N'Schema',@level0name = N'dbo',@level1type = N'Procedure',@level1name = N'SendMessageWithPriority'goexec sys.sp_addextendedproperty @name = N'SqlAssemblyFileLine', @value =26,@level0type = N'Schema',@level0name = N'dbo', @level1type = N'Procedure',@level1name = N'SendMessageWithPriority'go |
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-16 : 03:56:01
|
This is just adding extended property values for the procedure dbo.SendMessageWithPriority indicating which assembly it used, automdeployed status etchttp://msdn.microsoft.com/en-us/library/ms180047.aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
|