When creating a Sql Server CLR project in Visual Studio 2008, is there any way to specify the schema that an object (function, sproc, etc) should be created in when deploying the project? I'm thinking an Attribute on the function, something like... <ObjectSchema("MYSCHEMA")> Public Function Something() As SqlString ... code ... End Function Is there anything like this? Thanks in advance, Arthur Dent.
I'm pretty certain VS don't have that ability. But check out Niels' tool which according to his text can do this: http://nielsb.wordpress.com/sqlclrproject/ -- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://sqlblog.com/blogs/tibor_karaszi "Arthur Dent" wrote in message news:u$U1xyKzIHA.3504@TK2MSFTNGP06.phx.gbl... > When creating a Sql Server CLR project in Visual Studio 2008, is there any way to specify the > schema that an object (function, sproc, etc) should be created in when deploying the project? > > I'm thinking an Attribute on the function, something like... > > <ObjectSchema("MYSCHEMA")> Public Function Something() As SqlString > ... code ... > End Function > > Is there anything like this? > Thanks in advance, > Arthur Dent.
