SQL Server Performance

Specifying the schema for a CLR Stored Procedure made with VS2008

Discussion in 'SQL Server 2005 CLR' started by EMoscosoCam, Mar 23, 2008.

  1. EMoscosoCam Member

    Hello
    I would like to know if I can specify the schema for an stored procedure that is to be deployed using VS2008.
    Thanks a lot.
  2. satya Moderator

    Not sure what you mean by showing the schema for a CLR SP?
    Normally you can use SP to return the schema of a table or object, in thsi case you are asking otherway.
  3. EMoscosoCam Member

    I mean that the stored procedure is always created in the dbo schema; I'd rather set another.

Share This Page