Yukon UDT Help

  • Thread starter Thread starter Rod O.
  • Start date Start date
R

Rod O.

Hi all,

What is the syntax for adding a UDT that has a namespace? When I try

CREATE ASEMBLY Foo FROM "C:\Foo.dll" WITH PERMISSION_SET=SAFE
CREATE TYPE Bar EXTERNAL NAME Foo.SomeSpace.Bar

I receive the error

Incorrect syntax new '.'.

If I create the same UDT with no namespace, everything works fine.

Cheers,

Rod O.
 
Try enclosing the namespace qualified class name in square brackets. Like
assembly.[namespace.classname].
 
You need to take this to the beta newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005

--
----------------------------------------------------------------------------
Louis Davidson - (e-mail address removed)
SQL Server MVP

Compass Technology Management - www.compass.net
Pro SQL Server 2000 Database Design -
http://www.apress.com/book/bookDisplay.html?bID=266
Blog - http://spaces.msn.com/members/drsql/
Note: Please reply to the newsgroups only unless you are interested in
consulting services. All other replies may be ignored :)
 
Thanks Sushil! Worked like a charm.

Sushil said:
Try enclosing the namespace qualified class name in square brackets. Like
assembly.[namespace.classname].
Hi all,

What is the syntax for adding a UDT that has a namespace? When I try

CREATE ASEMBLY Foo FROM "C:\Foo.dll" WITH PERMISSION_SET=SAFE
CREATE TYPE Bar EXTERNAL NAME Foo.SomeSpace.Bar

I receive the error

Incorrect syntax new '.'.

If I create the same UDT with no namespace, everything works fine.

Cheers,

Rod O.
Click to expand...
Click to expand...
 
You are welcome :)
Rod O. said:
Thanks Sushil! Worked like a charm.

Sushil said:
Try enclosing the namespace qualified class name in square brackets. Like
assembly.[namespace.classname].
Hi all,

What is the syntax for adding a UDT that has a namespace? When I try

CREATE ASEMBLY Foo FROM "C:\Foo.dll" WITH PERMISSION_SET=SAFE
CREATE TYPE Bar EXTERNAL NAME Foo.SomeSpace.Bar

I receive the error

Incorrect syntax new '.'.

If I create the same UDT with no namespace, everything works fine.

Cheers,

Rod O.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top