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
 SQL Server Administration (2005)
 sp_OAMethod for Assemblies

Author  Topic 

natarshia
Starting Member

4 Posts

Posted - 2009-02-26 : 10:05:50
Does anyone know the correct syntax to generate the Assembly scripts using sp_OAMethod. I know you can generate the Assembly ddl using the gui, so there must be a way to code it in a stored procedure.

I can do tables, views, functions, etc.. but i keep getting an error when i try to use sp_OAMethod for Assemblies.

My client requires a file with all the DDL of the db objects, along with the backup.

thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-26 : 12:44:51
Duplicate, locking topic.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -