Script to deploy a stored procedure

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Script to deploy a stored procedure

Author

Topic

new2this
Starting Member

16 Posts

Posted - 2008-05-09 : 17:19:57

I keep getting the following message when I run a script to deploy a stored procedure in an assembly:

Could not find Type 'StoredProcedures' in assembly 'ApObjects'.

Here's the statement I used to deploy the assembly:
create assembly ApObjects
from 'D:\Documents\Visual Studio 2005\Projects\ApObjects\ApObjects\obj\Release\ApObjects.dll'

Here's the statement that causes the error above:
create proc GetTop10Vendors
as external name ApObjects.StoredProcedures.GetTop10Vendors

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-05-10 : 00:44:02

Have you done all steps shown here:-
http://www.dotnetfun.com/articles/sql/sql2005/SQL2005CLRSProc.aspx

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources