Error Create Aggregate

Question

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

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

raja_saminathan SSCommitted Points: 1607 More actions · Answer 1

Here is what I am trying to do

GO

CREATE ASSEMBLY ActiveDCom FROM '\Comms\ADCom\ActiveDirectoryCom.dll'

WITH permission_set = unsafe

go

CREATE Aggregate ADUserFullName

(@UserID char(100))

Returns char(100)

EXTERNAL NAME [ActiveDCom].[ActiveDirectoryCom.ADCom].[UserFullName];

GO

My dll Has a class ADCom with a function UserFull Name

I get this error

Incorrect syntax near '.'.

Hi ,

I think your error is in

EXTERNAL NAME [ActiveDCom].[ActiveDirectoryCom.ADCom].[UserFullName];

Try using like this

EXTERNAL NAME [ActiveDCom].[ActiveDirectoryCom].[ADCom].[UserFullName];

Regards,

Rajesh

pcplayer Mr or Mrs. 500 Points: 539 More actions · Answer 2

Thank you, I actually ended up Creating a Function. That was better to suit my needs. I finally got it to work using

AS EXTERNAL NAME ActiveDCom.[ActiveDirectoryCom.ADCom].UserFullName

Don't know why but this was the only way I could get it to work.

banawr Valued Member Points: 57 More actions · Answer 3

Format that works:

For funs and procs:

EXTERNAL NAME [NameOfAssembly].[namespaces.className].[funName]

For Aggregates:

EXTERNAL NAME [NameOfAssembly].[namespaces.className]