Deploy CLR UDF to a different SQL Schema

cpnet

Guest

Posts: n/a

14th May 2009

I have written a SQL Server (2005) scalar UDF in VS 2005. When I deploy my
UDF, it always creates it in the dbo schema in my database. Is there a way
to have it deploy to a different schema?

I tried using

SqlFunctionAttribute(Name="[MySchema].[MyUDFName]")

but that leaves me with a UDF named

[dbo].[[MySchema].[MyUDFName]]

in SQL server.

« Understanding FindName | ANN: Gnostice PDFOne .NET v2.1 released - Create, edit, view, print, secure, bookmark, watermark, merge and split PDF in .NET »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Deploy CLR UDF to a different SQL Schema	cpnet	Microsoft C# .NET	4	18th May 2009 01:44 PM
Can I sync a typed dataset schema with database schema easily?	John	Microsoft Dot NET	1	2nd Jan 2008 10:37 AM
can't create schema using .adp (or transfertext method renderred useless without schema)	kreplech@gmail.com	Microsoft Access	1	23rd Jun 2006 09:49 PM
DataSet ReadXmlSchema fails on a schema with (xsd:)imported schema	Eric van Wijk	Microsoft ADO .NET	0	27th Jul 2004 05:14 PM
2000 Schema - 2003 Schema >> Sunday	Ryan Rinehart	Microsoft Windows 2000 Active Directory	0	15th Aug 2003 07:05 PM