July 21, 2007 at 7:28 pm
Yesterday, I began the process of moving a database from SQL 2000 to SQL 2005. All is fine except that a stored procedure uses a external stored procedure (xp_getfiledetails) that has been retired. I went ahead and wrote a vb application to replace this stored procedure. My problem is that I can't create the assembly with the permission set of UNSAFE. Can someone please give me a recipe with an explanation of what is being done to allow me to create the assembly and use it in SQL 2005.
Thank you.
July 22, 2007 at 11:23 am
you will have to:
create a signed assembly in .net environment
create an asymentic key on sql server for the .net assembly
grant EXTERNAL_ACCESS or UNSAFE permission set to the .net assembly
probably create a login for the asymetric key
and you might additionally need to assign permissions to the user that is running the sql server process
July 23, 2007 at 11:45 am
Hello Bledu
Thank you for the information. I was able to get it to work. FYI -- you ARE required to create a login for the asymetric key.
Clay
July 23, 2007 at 11:59 am
July 23, 2007 at 12:30 pm
I tried to create the procedure WITHOUT creating the login and it Failed. After I created it, I was able to create the procedure.
July 23, 2007 at 12:44 pm
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy