Yukon UDT Help

[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.

 

[Sushil Chordia]

Try enclosing the namespace qualified class name in square brackets. Like
assembly.[namespace.classname].

 

[Louis Davidson]

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

 

[Rod O.]

Thanks Sushil! Worked like a charm.

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.

 

[Sushil Chordia]

You are welcome

Thanks Sushil! Worked like a charm.

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.