Yukon UDT Help

29 Mar 2005 1:40 AM

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.

29 Mar 2005 1:45 AM

Sushil Chordia

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

"Rod O." <rolafson-ngfil***@magickite.com> wrote in message
news:u8EZABANFHA.2132@TK2MSFTNGP14.phx.gbl...
> 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.

29 Mar 2005 11:57 PM

Rod O.

Thanks Sushil! Worked like a charm.

Sushil Chordia wrote:
Show quote

> Try enclosing the namespace qualified class name in square brackets. Like
> assembly.[namespace.classname].
> "Rod O." <rolafson-ngfil***@magickite.com> wrote in message
> news:u8EZABANFHA.2132@TK2MSFTNGP14.phx.gbl...
>
>>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.
>
>
>

30 Mar 2005 12:20 AM

Sushil Chordia

You are welcome :)
Show quote

"Rod O." <rolafson-ngfil***@magickite.com> wrote in message
news:OJJ3XsLNFHA.1732@TK2MSFTNGP14.phx.gbl...
> Thanks Sushil! Worked like a charm.
>
> Sushil Chordia wrote:
>> Try enclosing the namespace qualified class name in square brackets. Like
>> assembly.[namespace.classname].
>> "Rod O." <rolafson-ngfil***@magickite.com> wrote in message
>> news:u8EZABANFHA.2132@TK2MSFTNGP14.phx.gbl...
>>
>>>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.
>>
>>

29 Mar 2005 2:10 AM

Louis Davidson

You need to take this to the beta newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005

--
----------------------------------------------------------------------------
Louis Davidson - dr***@hotmail.com
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 :)

Show quote

"Rod O." <rolafson-ngfil***@magickite.com> wrote in message
news:u8EZABANFHA.2132@TK2MSFTNGP14.phx.gbl...
> 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.