Sunday, March 11, 2012

Yukon UDT Help

Try enclosing the namespace qualified class name in square brackets. Like
assembly.[namespace.classname].
"Rod O." <rolafson-ngfilter@.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.
You need to take this to the beta newsgroups:
http://communities.microsoft.com/newsgroups/default.asp?icp=sqlserver2005
--
----
Louis Davidson - drsql@.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 :)
"Rod O." <rolafson-ngfilter@.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.
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-ngfilter@.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.
>
>
You are welcome :)
"Rod O." <rolafson-ngfilter@.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-ngfilter@.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.
>>

No comments:

Post a Comment