• J i've got a question for you regarding deployment;

    i created a new VS project named "MyCLRProjects, and added only your Partial Public class as an example;

    it compiled, and i was able to run the command to add the assembly:

    CREATE ASSEMBLY MyCLRProjects from 'C:\data\MyCLRProjects.dll' WITH PERMISSION_SET = SAFE

    when i try to add the udf with the command below, i get this simple error:

    Msg 6505, Level 16, State 2, Procedure fn_ReadHttpPage, Line 1

    Could not find Type 'UserDefinedFunctions' in assembly 'MyCLRProjects'.

    the code:

    CREATE FUNCTION fn_ReadHttpPage(@pageToRead varchar(250))

    RETURNS varchar(max)

    EXTERNAL NAME MyCLRProjects.UserDefinedFunctions.ufnFunction

    can you point out my obvious error? i'm sure my Root namespace is simply "MyCLRProjects"

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!